OpenACS / openacs-4 / packages / search / sql / postgresql

upgrade

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 6
Last Commit: 24 Dec
Commits this week: 0
Total Lines of Code (LoC): 88
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 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -0
    • +36
    ./upgrade-5.10.0d3-5.10.0d4.sql
  2. … 8099 more files in changeset.
Monday 01 Mar 2021
7:20 pm

gustafn

Handle potential race condition in search observer queue maintenance

In some cases, when e.g. objects are quicky deleted after updates, the

object might be already be deleted when being tried to trigger a

DELETE operation in the search queue. as a consequence, one can sometimes

observer errors like the one below. The new code double-checks now,

if the object for the DELETE operation still exists.

ERROR: insert or update on table "search_observer_queue" violates foreign key constraint "search_observer_queue_object_id_fk"

: DETAIL: Key (object_id)=(497509146) is not present in table "acs_objects".

: CONTEXT: SQL statement "insert into search_observer_queue (

Options
    • -0
    • +36
    ./upgrade-5.10.0d3-5.10.0d4.sql
  2. … 4 more files in changeset.
7:20 pm

gustafn

file upgrade-5.10.0d3-5.10.0d4.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade-5.10.0d3-5.10.0d4.sql
  2. … 1 more file in changeset.
Saturday 30 Mar 2013
7:50 pm

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -9
    • +18
    ./upgrade-4.5-4.5.1.sql
  2. … 19 more files in changeset.
Monday 26 Jul 2004
3:04 pm

jeffd

add a syndication table which holds xml fragments which can be assembled to create rss feeds

Options
    • -0
    • +3
    ./upgrade-5.2.0d2-5.2.0d3.sql
  2. … 6 more files in changeset.
Friday 14 May 2004
12:17 pm

jeffd

Put functions into a search:: namespace and make most private.

Add a search::queue and search::dequeue command

define_function_args/package_exec_plsql to avoid db specific xql files.

unset datasource when finished with it.

bump to 5.2.0d2 + postgresql upgrade script.

Options
    • -0
    • +5
    ./upgrade-5.2.0d1-5.2.0d2.sql
  2. … 6 more files in changeset.
Monday 13 Oct 2003
12:20 am

tilmanns

Applied fix from Carsten Clasohm - now upgrade works on pg7.3 as well (tried it on 7.2 too). Fixes #631

Options
    • -2
    • +2
    ./upgrade-4.5-4.5.1.sql
Saturday 17 May 2003
1:23 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -1
    • +1
    ./upgrade-4.5-4.5.1.sql
  2. … 29 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -2
    • +2
    ./upgrade-4.5-4.5.1.sql
  2. … 54 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -2
    • +2
    ./upgrade-4.5-4.5.1.sql
  2. … 54 more files in changeset.
Saturday 03 Aug 2002
8:00 pm

vinodk

renamed jon's upgrade file 4.5->4.5.1

Options
    • -35
    • +0
    ./upgrade-4.2-4.5.1.sql
    • -0
    • +35
    ./upgrade-4.5-4.5.1.sql
2:39 am

jong

initial revision

Options
    • -0
    • +35
    ./upgrade-4.2-4.5.1.sql