tsearch2-driver-procs-postgresql.xql

  • last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce duplication:

index and update_index were in fact implementing a upsert logic. Modern sql allows to write this in a single query and merge the two apis into one. Replace reference in the service contracts as well.

    • -18
    • +17
    ./tsearch2-driver-procs-postgresql.xql
  1. … 5 more files in changeset.
remove spurious parens

    • -1
    • +1
    ./tsearch2-driver-procs-postgresql.xql
Make sure object_id is still a valid acs_object by the time it gets to the indexer: it can happen that objects meant to be indexed are in fact short-lived (e.g. xowiki-based objects created, scheduled for indexing and deleted shortly after)

    • -4
    • +5
    ./tsearch2-driver-procs-postgresql.xql
Use "package defined" stored procedure instead of legacy nomenclature

    • -1
    • +1
    ./tsearch2-driver-procs-postgresql.xql
Since PostgreSQL 10 does not support the tsearch2 backword compatibility package anymore, make sure that OpenACS does not use the old names requiring this package.

    • -43
    • +0
    ./tsearch2-driver-procs-postgresql.xql
merged changes from the oacs-5-9 branch and resolved conflicts

    • -37
    • +9
    ./tsearch2-driver-procs-postgresql.xql
  1. … 7834 more files in changeset.
- improve formatting

    • -13
    • +9
    ./tsearch2-driver-procs-postgresql.xql
- remove obsolete queries

    • -24
    • +0
    ./tsearch2-driver-procs-postgresql.xql
Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

    • -4
    • +2
    ./tsearch2-driver-procs-postgresql.xql
  1. … 520 more files in changeset.
- provide default values, concentrate concerns

    • -4
    • +2
    ./tsearch2-driver-procs-postgresql.xql
  1. … 1 more file in changeset.
Rewriting acs_permission__permission_p function to use recursive queries ( available in PG since 8.4 ) and modifiying

queries around core packages to avoid checking persmissions using a subquery on the acs_object_party_privilege_map view.

    • -0
    • +37
    ./tsearch2-driver-procs-postgresql.xql
  1. … 14 more files in changeset.
Fix count query to also honor the extra_args

    • -0
    • +24
    ./tsearch2-driver-procs-postgresql.xql
  1. … 1 more file in changeset.
Implement TIP#130 Add -exta_args to search callback definition to avoid having to redefine it constantly

    • -7
    • +17
    ./tsearch2-driver-procs-postgresql.xql
  1. … 4 more files in changeset.
Fix typo in query names

    • -2
    • +2
    ./tsearch2-driver-procs-postgresql.xql
More missing defaults

    • -3
    • +3
    ./tsearch2-driver-procs-postgresql.xql
Add default config for PG < 8.3 query.

    • -3
    • +3
    ./tsearch2-driver-procs-postgresql.xql
Fix postgtresql 8.3 compatibility for another query.

    • -6
    • +27
    ./tsearch2-driver-procs-postgresql.xql
  1. … 1 more file in changeset.
Hopefully found the secret to customizing queries by version

    • -1
    • +44
    ./tsearch2-driver-procs-postgresql.xql
  1. … 2 more files in changeset.
Fucking query processor only allows one queryset per xql file

    • -42
    • +0
    ./tsearch2-driver-procs-postgresql.xql
  1. … 1 more file in changeset.
Broke out 8.3 vs. old tsearch queries into a query file and conditionalized

by version. Did not break out queries not affected by 8.3.

    • -0
    • +81
    ./tsearch2-driver-procs-postgresql.xql
  1. … 1 more file in changeset.