OpenACS / openacs-4 / packages / tsearch2-driver / tcl

tsearch2-driver-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 07 Nov 17
Commits this week: 0
Total Lines of Code (LoC): 101
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 30 Apr 2021
7:42 pm

antoniop

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.

Options
    • -18
    • +17
    ./tsearch2-driver-procs-postgresql.xql
  2. … 5 more files in changeset.
Monday 18 May 2020
10:46 pm

gustafn

remove spurious parens

Options
    • -1
    • +1
    ./tsearch2-driver-procs-postgresql.xql
Monday 09 Mar 2020
1:58 pm

antoniop

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)

Options
    • -4
    • +5
    ./tsearch2-driver-procs-postgresql.xql
Friday 15 Mar 2019
9:54 am

antoniop

Use "package defined" stored procedure instead of legacy nomenclature

Options
    • -1
    • +1
    ./tsearch2-driver-procs-postgresql.xql
Tuesday 07 Nov 2017
10:33 am

gustafn

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.

Options
    • -43
    • +0
    ./tsearch2-driver-procs-postgresql.xql
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -37
    • +9
    ./tsearch2-driver-procs-postgresql.xql
  2. … 7834 more files in changeset.
Friday 05 Aug 2016
4:38 pm

gustafn

- improve formatting

Options
    • -13
    • +9
    ./tsearch2-driver-procs-postgresql.xql
Sunday 03 Jul 2016
7:58 pm

gustafn

- remove obsolete queries

Options
    • -24
    • +0
    ./tsearch2-driver-procs-postgresql.xql
Monday 27 Apr 2015
5:28 pm

victorg

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

Options
    • -4
    • +2
    ./tsearch2-driver-procs-postgresql.xql
  2. … 520 more files in changeset.
Thursday 27 Nov 2014
10:48 am

gustafn

- provide default values, concentrate concerns

Options
    • -4
    • +2
    ./tsearch2-driver-procs-postgresql.xql
  2. … 1 more file in changeset.
Tuesday 02 Apr 2013
1:05 pm

victorg

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.

Options
    • -0
    • +37
    ./tsearch2-driver-procs-postgresql.xql
  2. … 14 more files in changeset.
Friday 05 Nov 2010
5:35 pm

daveb

Fix count query to also honor the extra_args

Options
    • -0
    • +24
    ./tsearch2-driver-procs-postgresql.xql
  2. … 1 more file in changeset.
Friday 13 Mar 2009
7:57 pm

daveb

Implement TIP#130 Add -exta_args to search callback definition to avoid having to redefine it constantly

Options
    • -7
    • +17
    ./tsearch2-driver-procs-postgresql.xql
  2. … 4 more files in changeset.
Monday 20 Oct 2008
7:03 pm

daveb

Fix typo in query names

Options
    • -2
    • +2
    ./tsearch2-driver-procs-postgresql.xql
Monday 22 Sep 2008
6:51 pm

daveb

More missing defaults

Options
    • -3
    • +3
    ./tsearch2-driver-procs-postgresql.xql
6:32 pm

daveb

Add default config for PG < 8.3 query.

Options
    • -3
    • +3
    ./tsearch2-driver-procs-postgresql.xql
6:26 pm

daveb

Fix postgtresql 8.3 compatibility for another query.

Options
    • -6
    • +27
    ./tsearch2-driver-procs-postgresql.xql
  2. … 1 more file in changeset.
Tuesday 05 Aug 2008
4:54 pm

donb

Hopefully found the secret to customizing queries by version

Options
    • -1
    • +44
    ./tsearch2-driver-procs-postgresql.xql
  2. … 2 more files in changeset.
4:33 pm

donb

Fucking query processor only allows one queryset per xql file

Options
    • -42
    • +0
    ./tsearch2-driver-procs-postgresql.xql
  2. … 1 more file in changeset.
3:51 pm

donb

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.

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