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

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 40
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 32,399
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 19 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 29 Oct 2002
2:51 am

vinodk

file upgrade-4.5-4.6.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.5-4.6.sql
  2. … 3 more files in changeset.
2:51 am

vinodk

- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

Options
    • -2
    • +1
    ./content-keyword.sql
    • -0
    • +248
    ./upgrade/upgrade-4.5-4.6.sql
  3. … 29 more files in changeset.
Friday 04 Oct 2002
10:08 am

jeffd

undeclared variable in trigger bug 1769/patch 467 Dave Bauer

Options
    • -1
    • +1
    ./content-image.sql
    • -0
    • +3
    ./content-search.sql
    • -1
    • +1
    ./types-drop.sql
Thursday 03 Oct 2002
9:30 pm

jeffd

do not drop non-existent trigger

Options
    • -1
    • +2
    ./content-search.sql
Friday 27 Sep 2002
5:32 pm

rmello

Change triggers to index only live revisions by Dave Bauer, 2002-09-26

triggers queue search interface to modify search index after content

changes

Options
    • -12
    • +43
    ./content-search.sql
  2. … 1 more file in changeset.
Monday 23 Sep 2002
12:19 pm

jeffd

adds some common mime types to cr_mime_types

Options
    • -4
    • +25
    ./content-create.sql
  2. … 1 more file in changeset.
Thursday 19 Sep 2002
4:02 am

danw

cleanup

Options
    • -2
    • +2
    ./content-type.sql
  2. … 1 more file in changeset.
Monday 26 Aug 2002
7:02 pm

danw

fixed problem with content type view insert rule - fix provided by Jun Yumog

Options
    • -2
    • +2
    ./content-type.sql
Saturday 17 Aug 2002
7:42 pm

vinodk

Re-added fixes that didn't get merged in from 4.5

1) bboard-procs-postgresql.xql

2) etp-procs-oracle.xql

3) subsite/www/admin/users/new-postgresql.xql

4) SQL fix in acs-kernel/sql/postgresql/apm-create.sql

Edited the acs-kernel upgrade script that JonG initially created (PG)

Created an oracle upgrade script

Added upgrade scripts that i had written for 4.5b->4.5 back in (didn't get merged)

Update the acs-kernel .info file to 4.5.1

Options
    • -0
    • +26
    ./upgrade/upgrade-4.1.2-4.5.sql
  2. … 8 more files in changeset.
Tuesday 09 Jul 2002
5:43 pm

jeffd

Do not pass title to content_item__new since it forces it to create a

content revision in which to store it (and we are going to

create it ourselves as the next step).

Options
    • -1
    • +1
    ./content-image.sql
Saturday 25 May 2002
4:30 pm

yon

removed content_item.update_last_modified, use acs_object.update_last_modified instead

Options
    • -28
    • +1
    ./content-item.sql
    • -5
    • +0
    ./packages-create.sql
  3. … 2 more files in changeset.
Thursday 16 May 2002
12:27 am

vinodk

Added upgrade script for CR 4.1.2->4.5

Options
    • -0
    • +26
    ./upgrade/upgrade-4.1.2-4.5.sql
12:27 am

vinodk

file upgrade-4.1.2-4.5.sql was initially added on branch oacs-4-5.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.1.2-4.5.sql
Sunday 12 May 2002
11:22 pm

donb

Committed Vinod Kurup's patch #1502 which fixed a file-storage bug.

Options
    • -2
    • +1
    ./content-keyword.sql
10:57 pm

donb

Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

Options
    • -17
    • +4
    ./content-image.sql
  2. … 58 more files in changeset.
Thursday 04 Apr 2002
5:00 am

yon

added function for updating last_modified time of a content_item with cascading

Options
    • -2
    • +28
    ./content-item.sql
    • -0
    • +4
    ./packages-create.sql
  3. … 2 more files in changeset.
Sunday 31 Mar 2002
10:31 pm

donb

Applied Jowell Sabino's patch #215 which fixes a problem with image deletion.

Options
    • -17
    • +4
    ./content-image.sql
Wednesday 27 Feb 2002
6:02 am

vinodk

fixed 2 typos in content_revision__get_content

Options
    • -4
    • +3
    ./content-revision.sql
Sunday 10 Feb 2002
11:11 pm

neophytosd

applied patches 130,131,132,133,134,135,137

Options
    • -3
    • +4
    ./content-item.sql
  2. … 7 more files in changeset.
Wednesday 16 Jan 2002
9:07 pm

donb

1. home.tcl - applied patch from SDM to use ad_pvt_home rather than a

fixed value.

2. defs-procs.tcl - applied patch that fixed a "link within a link" problem.

3. content_item.tree_sortkey had no index (gulp!)

Options
    • -1
    • +2
    ./content-create.sql
  2. … 2 more files in changeset.
Wednesday 02 Jan 2002
8:54 pm

andrewg

Replacing call to non-existent content_revision__delete_revision with a call to content_revision__delete.

Options
    • -1
    • +1
    ./content-image.sql
Sunday 09 Dec 2001
5:21 am

donb

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

Options
    • -1
    • +15
    ./content-create.sql
    • -3
    • +1
    ./content-item.sql
    • -2
    • +0
    ./content-keyword.sql
    • -21
    • +14
    ./content-perms.sql
  5. … 15 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -40
    • +31
    ./content-create.sql
    • -46
    • +26
    ./content-folder.sql
    • -41
    • +19
    ./content-item.sql
    • -41
    • +23
    ./content-keyword.sql
    • -28
    • +16
    ./content-perms.sql
    • -19
    • +9
    ./content-revision.sql
    • -41
    • +19
    ./content-type.sql
    • -6
    • +5
    ./types-create.sql
  9. … 55 more files in changeset.
Saturday 01 Dec 2001
4:41 pm

donb

After importing openacs.org users, forums and messages I discovered that it

took literally several minutes to load the APM's home page. This was due

to a rather stupid subselect of the form:

select count(*)

from content_revisions r

where r.revision_id = content_item.get_latest_revision(item_id)

where item_id comes from the package versions table.

It's stupid in both PG and Oracle because get_latest_revision already

joins the latest_revision_id value from cr_items with the content

revisions table thus a simple check for a null return by get_latest_revision

would be sufficient.

It's *really* stupid in Oracle because Oracle won't use the index on

revision_id when checking NULLs so we get two sequential scans of the

cr_revisions table tucked into that one itty-bitty subquery (itself called

once for each package version in ths system).

Which explains why I hadn't noticed it while working on scalability testing

in PG - PG uses the index because its btree index structure handles NULLs.

Meaning this query only fell apart at a rate of O(log2(R)) rather than O(R)

as in Oracle (R being the number of revision objects in the system).

My solution was to rewrite the subselect using "case" rather than "count(*)"

and also to speed up get_latest_revision by having it check for NULL and

return NULL immediately rather than execute the query (in PG this is

accomplished by declaring the function "isstrict", and the executor won't

even call the function if the argument's NULL, making it REALLY fast!).

Options
    • -2
    • +2
    ./content-item.sql
  2. … 3 more files in changeset.
Thursday 15 Nov 2001
2:47 am

donb

1. Fixed permissions bug in the PG version (missing OR clause in a view)

2. Added (untested thus far) site-wide-search to glossary

3. Added centralized support for importing files into the CR (either into

the filesystem or the database).

4. Fixed wp-slim. Fixed it some more. Fixed it again. It still needs

more fixing.

Options
    • -1
    • +3
    ./content-create.sql
    • -1
    • +6
    ./content-image-drop.sql
    • -1
    • +128
    ./content-image.sql
    • -7
    • +7
    ./content-item.sql
  5. … 58 more files in changeset.
Wednesday 07 Nov 2001
11:55 pm

donb

1. Typo in the alter table in the PG version ...

2. Just folded the alter tables into the cr_folders table definition. This

is still pre-beta ...

Options
    • -4
    • +5
    ./content-create.sql
  2. … 1 more file in changeset.
5:12 am

jong

added a constraint

Options
    • -2
    • +5
    ./content-create.sql
4:54 am

jong

added package_id to cr_folders

Options
    • -1
    • +6
    ./content-create.sql
Tuesday 23 Oct 2001
9:41 pm

donb

Dave Bauer's patches ...

Options
    • -2
    • +83
    ./content-folder.sql
    • -167
    • +5
    ./content-item.sql
Wednesday 03 Oct 2001
6:41 am

danw

fixed infinite recursion problem with cr_keywords update trigger

Options
    • -2
    • +4
    ./content-create.sql