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

content-revision.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 821
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 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./content-revision.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -2
    • +3
    ./content-revision.sql
  2. … 8099 more files in changeset.
Friday 18 Jun 2021
3:57 pm

hectorr

Use 'revision_id' as a tiebreaker in case creation_date is the same, which can happen if different revisions were created inside a single transaction.

Options
    • -2
    • +3
    ./content-revision.sql
  2. … 2 more files in changeset.
Saturday 24 Mar 2018
12:53 am

hectorr

Fix more typos

Options
    • -2
    • +2
    ./content-revision.sql
  2. … 84 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -204
    • +111
    ./content-revision.sql
  2. … 7834 more files in changeset.
Sunday 12 Feb 2017
1:15 am

gustafn

- Align type of parameter "storage_type" with type definition of cr_items.storage_type

- bump version to 5.9.1d27

Options
    • -3
    • +3
    ./content-revision.sql
  2. … 3 more files in changeset.
Tuesday 06 Dec 2016
1:04 pm

gustafn

- fix cr_revision_latest_tr once more to reduce the number of dead tuples generated for xo* classes

- bump version number to 5.9.1d25

Options
    • -5
    • +9
    ./content-revision.sql
  2. … 2 more files in changeset.
Sunday 27 Nov 2016
11:10 am

gustafn

Reduced generation of dead tuples in postgres.

Background: In the old version, the fields latest and live

revisions were updated always via two separate dmlDML statements.

Every update causes in PostgreSQL (tested to pg 9.6) one more dead

tuple, such that on busy systems, we see 30k + dead tuples per

hour. These dead tuples in turn cause more auto vacuum operations

and can lead to abandoned query plans.

This change can reduce the number of dead tuples on cr_items into

half, by allowing both fields to be set in one operation (namely

content_item__set_live_revision). This function has an optional 4th

argument that can cause this optimization. For legacy applications,

nothing changes.

Btw: since all commonly used applications use the live revision, the

fallback of the latest_revision is unused. One can consider to

remove the cr_revision_latest_tr, at least on on certain

installations.

bump revision to 5.1.9d23

Options
    • -6
    • +13
    ./content-revision.sql
  2. … 3 more files in changeset.
Wednesday 10 Feb 2016
10:14 am

gustafn

Content-Repository Reform : Reduction of number of functions in

the content repository for PostgreSQL by using using argument defaults

(while providing compatibility for clients using old versions):

- reduced number of versions of content_item__new from 12 (!) to 6 by using defaults

- commented differences

- commented arguments of plpgsql functions with long argument lists

- reduced code duplication by basing one version of content_item__new/17 directly on /20

- marking on version of content_item__new/17 and content_item__new/6 as deprecated

- reduced number of versions of content_revision__new from 7 to 4 by using defaults

- commented differences

- marking on version of content_revision__new/7 as deprecated

- let automatically generated functions call directly content_revision__new/13

- remove space from automatically generated functions

- updated automatically generated functions for all types of the content repository

- reduced number of versions of image__new from 4 to 2by using defaults

- reduced number of versions of image__new_revision from 2 to 1 by using defaults

Options
    • -197
    • +93
    ./content-revision.sql
  2. … 7 more files in changeset.
Sunday 03 May 2015
2:32 pm

gustafn

Scalability reform part 3 (content-repository):

- content_revision__del:

* Removed manual nulling of live_revision and latest_revision

by using appropriate ond delete actions on foreign keys

* Removed manual deletion of old_revision and new_revision in

cr_item_publish_audit by using "on delete cascade"

- content_item__del:

* Removed manual deletion of item_id in cr_item_publish_audit

by using "on delete cascade"

* Removed manual deletion of item_id in cr_release_periods

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_template_map

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_keyword_map

by using "on delete cascade"

* Removed manual deletion of direct permissions (was already

cascading)

- Added missing index for child_id to cr_child_rels.

This index was in the create scripts (with a non-conformant name),

but not in the upgrade scripts

- bump version number of acs-content-repository to 5.9.0d3

Options
    • -59
    • +41
    ./content-revision.sql
  2. … 4 more files in changeset.
Thursday 07 Jul 2011
12:46 pm

gustafn

Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is

optional).

- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

Options
    • -210
    • +354
    ./content-revision.sql
  2. … 54 more files in changeset.
Tuesday 10 Feb 2009
7:31 pm

jeffd

switch foo_id_seq.netval to nextval('t_foo_id_seq') calls to placate postgresql 8.

Options
    • -2
    • +2
    ./content-revision.sql
  2. … 8 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -3
    • +4
    ./content-revision.sql
  2. … 721 more files in changeset.
Thursday 07 Jul 2005
1:31 am

donb

Aesthetic changes, removed oracle cruft left in as comments by Dan Wickstrom's

original conservsion scripts ( while working on allowing null type table names).

Options
    • -46
    • +1
    ./content-revision.sql
  2. … 2 more files in changeset.
Sunday 05 Jun 2005
6:38 pm

daveb

Fix bug#1937 with patch#548. Use full syntax for inserts so integer

values work on content_revision__copy in PostgreSQL.

Options
    • -3
    • +4
    ./content-revision.sql
  2. … 1 more file in changeset.
Sunday 20 Mar 2005
4:58 pm

jeffd

fix laundry list of bugs in content repository copy code.

duplicate version of the 11arg content_folder__new

copy_creation_ip rather than copy__creation_ip in content_revision__copy

content_folder__copy did not preserve context_id properly

content_item__copy2 had a bunch of unused varaibles -- removed them.

content_item__copy now preserves live_revision so things which copy an

item with a live revision to not have to explicitly publish the new copy

(which eg file storage did not do).

content_revision__copy did an insert into acs_objects without specifying

column names which breaks on a new install since the order is not as expected.

Options
    • -30
    • +25
    ./content-revision.sql
  2. … 3 more files in changeset.
Thursday 03 Mar 2005
6:56 pm

daveb

Add content_revision__del

Options
    • -2
    • +2
    ./content-revision.sql
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -2
    • +1
    ./content-revision.sql
  2. … 2275 more files in changeset.
Tuesday 11 Jan 2005
7:51 pm

daveb

Properly create content_revision__del. Fixes bug#2251

Options
    • -2
    • +2
    ./content-revision.sql
Thursday 06 Jan 2005
5:52 pm

daveb

Fix __delete functions to have __del variant.

Options
    • -2
    • +12
    ./content-revision.sql
  2. … 5 more files in changeset.
5:31 pm

daveb

Add __del function to match oracle so package_exec_plsql will work

Options
    • -2
    • +13
    ./content-revision.sql
  2. … 2 more files in changeset.
Tuesday 21 Dec 2004
7:22 pm

daveb

Add CR Tcl API from HEAD.

Options
    • -1
    • +10
    ./content-revision.sql
  2. … 17 more files in changeset.
Thursday 12 Aug 2004
8:51 pm

josee

fixing bug with the copy_content function, moving the call to lob_copy before the update

Options
    • -2
    • +6
    ./content-revision.sql
Thursday 01 Jul 2004
6:33 pm

jeffd

add define_function_args definitions for most functions, bump to 5.2.0d5, upgrade script

Options
    • -0
    • +11
    ./content-revision.sql
  2. … 9 more files in changeset.
Friday 12 Mar 2004
8:19 pm

jeffd

various bug fixes for package_id, title addition to acs_objects

Options
    • -2
    • +2
    ./content-revision.sql
  2. … 12 more files in changeset.
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -6
    • +123
    ./content-revision.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -122
    • +5
    ./content-revision.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -6
    • +123
    ./content-revision.sql
  2. … 96 more files in changeset.
Friday 06 Feb 2004
9:02 pm

donb

Added define_function_arg calls to non-content-revision objects and to

create_type and create_attributes, so we can do these operations via

Tcl. Content revisions, due to LOB/non-LOB issues and the incompatibility

of LOB operations between DBs need their own "smart" Tcl API.

Options
    • -1
    • +7
    ./content-revision.sql
  2. … 10 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -47
    • +35
    ./content-revision.sql
  2. … 598 more files in changeset.