OpenACS / openacs-4 / packages / acs-content-repository / sql / postgresql

upgrade

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 25
Last Commit: 25 Jun
Commits this week: 0
Total Lines of Code (LoC): 20,362
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 24 Apr 2011
11:28 pm

donb

1. Added "--default foo" style comments to new PL/pgSQL function parameters

because xotcl-core, rather than use the metadata created by define_function_params,

ASSIGNS SEMANTICS TO THESE SQL COMMENTS. Bah. If I truly cared about quality

I'd insist the xotcl people fix their code and do things right, but I know that

would never happen so ... kludge away.

2. xotcl-core adds CR attributes (rather than fix core). So my fixing of

core conflicts, meaning I have to kludge again. Still needs to be fixed

for oracle.

Options
    • -2
    • +13
    ./upgrade-5.7.0d3-5.7.0d4.sql
  2. … 3 more files in changeset.
Monday 11 Apr 2011
2:28 am

donb

Adding a couple of attributes to make packages working with meta-data less

kludgey. PG-only with this commit, Oracle to follow.

Options
    • -0
    • +25
    ./upgrade-5.7.0d3-5.7.0d4.sql
  2. … 2 more files in changeset.
Sunday 20 Feb 2011
1:34 am

donb

Moved table building and column adding code from content repository to

kernel, so all objects can benefit. Part of the acs object management package

work.

Options
    • -2
    • +12
    ./upgrade-5.7.0d2-5.7.0d3.sql
  2. … 5 more files in changeset.
Sunday 30 Jan 2011
2:36 am

donb

Upgrade scripts for changes on object metadata creation (adding automatic

table and column creation to base objects as well as CR object, object views,

etc).

Options
    • -0
    • +105
    ./upgrade-5.7.0d2-5.7.0d3.sql
  2. … 3 more files in changeset.
Monday 04 Oct 2010
11:59 pm

victorg

Changes for supporting postgresql 9.0:

- Avoiding usage of SQL reserved keywords on plpsql functions (plpsql lexer and parser were reworked).

- Fixing all those places on which FROM clause was automatically added by PG ( PG Config add_missing_from parameter was removed for this release of PG ).

Many thanks to Tracy Adams and Jeff Lu for providing first version of the patches.

Options
    • -0
    • +147
    ./upgrade-5.7.0d1-5.7.0d2.sql
  2. … 16 more files in changeset.
Wednesday 27 Jan 2010
6:34 pm

daveb

Make sure you always cascade when dropping the views or it will fail.

Options
    • -0
    • +337
    ./upgrade-5.6.0d3-5.6.0d4.sql
  2. … 2 more files in changeset.
Tuesday 13 Oct 2009
12:40 am

daveb

Fix support for NULL table name in CR-derived object types

Options
    • -0
    • +212
    ./upgrade-5.6.0d2-5.6.0d3.sql
  2. … 4 more files in changeset.
Friday 03 Apr 2009
12:31 am

donb

Fixed a problem with the deletion of lob.sql-based ("pseudo-lob") binary

storage.

Options
    • -0
    • +6
    ./upgrade-5.5.0d3-5.5.0d4.sql
  2. … 2 more files in changeset.
Friday 24 Oct 2008
3:50 pm

victorg

Checking that the copy.name is not null when copying it to same parent folder

of the source folder.

Options
    • -2
    • +2
    ./upgrade-5.5.0d2-5.5.0d3.sql
  2. … 3 more files in changeset.
Thursday 23 Oct 2008
3:04 pm

victorg

Adding basic checks to content_folder.copy procedure in order to avoid

infinit loops.

Options
    • -0
    • +125
    ./upgrade-5.5.0d2-5.5.0d3.sql
  2. … 4 more files in changeset.
Friday 15 Aug 2008
9:36 pm

donb

Upgrade script for increasing maximum length of a cr type name.

Options
    • -0
    • +106
    ./upgrade-5.5.0d1-5.5.0d2.sql
  2. … 1 more file in changeset.
Friday 01 Aug 2008
10:37 am

emmar

Removed files that have been removed on oacs-5-4 but not merged to HEAD

Options
    • -2
    • +0
    ./upgrade-5.3.0d4-5.3.0d5.sql
    • -793
    • +0
    ./upgrade-5.3.0d6-5.3.0d7.sql
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -0
    • +2
    ./upgrade-5.4.2d1-5.4.2d2.sql
  2. … 283 more files in changeset.
Friday 25 Apr 2008
9:29 pm

daveb

Remove unecessary upgrades.

Fix RI trigger now that we require PG 8 we don't need the workaround in

cr_folders.

Options
    • -2
    • +0
    ./upgrade-5.3.0d4-5.3.0d5.sql
    • -793
    • +0
    ./upgrade-5.3.0d6-5.3.0d7.sql
    • -0
    • +2
    ./upgrade-5.4.2d1-5.4.2d2.sql
  4. … 2 more files in changeset.
9:29 pm

daveb

file upgrade-5.4.2d1-5.4.2d2.sql was initially added on branch oacs-5-4.

Options
    • -0
    • +0
    ./upgrade-5.4.2d1-5.4.2d2.sql
Tuesday 11 Mar 2008
3:22 pm

daveb

Fix content_type__is_content_type define function args to match Tcl

procedure and Oracle signature. The argument is called object_type.

Options
    • -0
    • +9
    ./upgrade-5.4.1d1-5.4.1d2.sql
  2. … 1 more file in changeset.
Monday 01 Oct 2007
12:44 pm

gustafn

new update script in case, someone managed to get the .info file without the update script

Options
    • -0
    • +146
    ./upgrade-5.4.0d7-5.4.0d8.sql
    • -0
    • +360
    ./upgrade-5.4.0d8-5.4.0d9.sql
  3. … 1 more file in changeset.
Tuesday 25 Sep 2007
5:22 pm

donb

Merged 5.3 to HEAD

Options
    • -26
    • +1
    ./upgrade-5.2.1d1-5.2.1d2.sql
  2. … 60 more files in changeset.
Monday 17 Sep 2007
3:00 pm

maltes

Missing upgrade scripts

Options
    • -0
    • +9
    ./upgrade-5.4.0d6-5.4.0d7.sql
  2. … 4 more files in changeset.
11:43 am

gustafn

Get rid of the postgres warning "adding missing FROM-clause entry " on sequences

Make "db_nextval acs_object_id_seq" more than twice as fast (from 948 microseconds to 378 microseconds)

Options
    • -0
    • +839
    ./upgrade-5.4.0d4-5.4.0d5.sql
  2. … 9 more files in changeset.
Saturday 15 Sep 2007
8:15 pm

gustafn

adding upgrade script

Options
    • -0
    • +2
    ./upgrade-5.4.0d3-5.4.0d4.sql
Saturday 19 May 2007
9:55 pm

maltes

This old version of the view update is superseeded by upgrade-5.3.0d1, apart from the fact that on none of my sites moving from pre 5.2 it has been working on an upgrade (usually fails due to image content type)

Options
    • -26
    • +1
    ./upgrade-5.2.1d1-5.2.1d2.sql
Monday 14 May 2007
10:30 pm

donb

Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

Options
    • -0
    • +9
    ./upgrade-5.3.0b1-5.3.0b2.sql
    • -0
    • +288
    ./upgrade-5.3.0b2-5.3.0b3.sql
    • -1
    • +1
    ./upgrade-5.3.0d1-5.3.0d2.sql
  4. … 322 more files in changeset.
Wednesday 10 Jan 2007
6:32 pm

daveb

Move content_revision__new functions to a seperate upgrade script that

will run after beta2.

Options
    • -281
    • +1
    ./upgrade-5.3.0b1-5.3.0b2.sql
    • -0
    • +288
    ./upgrade-5.3.0b2-5.3.0b3.sql
6:32 pm

daveb

file upgrade-5.3.0b2-5.3.0b3.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./upgrade-5.3.0b2-5.3.0b3.sql
6:23 pm

daveb

Recreate all content_revision__new functions.

Options
    • -2
    • +282
    ./upgrade-5.3.0b1-5.3.0b2.sql
Tuesday 09 Jan 2007
7:48 pm

daveb

Recreating the trigger without recreating the view can cause a problem

in a very specific case. It doesn't hurt to recreate the view (which

calls refresh_trigger)

Options
    • -1
    • +1
    ./upgrade-5.3.0d1-5.3.0d2.sql
Wednesday 03 Jan 2007
10:06 pm

daveb

Fix upgrade script to update the correct revision_id for the template

since template_id is a cr_items.item_id.

Options
    • -1
    • +1
    ./upgrade-5.3.0b1-5.3.0b2.sql
10:00 pm

daveb

file upgrade-5.3.0b1-5.3.0b2.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./upgrade-5.3.0b1-5.3.0b2.sql
10:00 pm

daveb

Update default template to use text instead of content tag to property grab

text from filesystem stored revisions.

Options
    • -0
    • +9
    ./upgrade-5.3.0b1-5.3.0b2.sql
  2. … 1 more file in changeset.