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

content-item.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 18
Last Commit: 11:24
Commits this week: 0
Total Lines of Code (LoC): 2,466
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 07 Nov 2003
3:05 am

daveb

Added optional name parameter to content_item content_folder content_extlink

content_symlink copy and move pl(pg)sql procedures. Oracle and Postgresql.

Options
    • -52
    • +109
    ./content-item.sql
  2. … 7 more files in changeset.
Saturday 17 May 2003
11:35 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -77
    • +17
    ./content-item.sql
  2. … 101 more files in changeset.
Thursday 20 Mar 2003
11:09 pm

donb

Removed the vile fs_simple_objects added by OF to store URLs in file

storage despite the existence of a non-versioned URL type in the content

repository. Upgrade scripts provided. I added Tcl API to the content

repository to honor our desire to export the SQL API to Tcl client code.

1. folder contents are now counted correctly (bug fix)

2. The fs_objects view is now usable in PG (it was a UNION view before and

therefore didn't scale)

3. Code in file storage is considerably simpler now and all file storage

objects are now stored in the content repository, as they should

be.

The Oracle version may need some work I'll finish testing this afternoon.

Options
    • -70
    • +11
    ./content-item.sql
  2. … 46 more files in changeset.
Saturday 01 Mar 2003
10:20 pm

donb

Partial conversion from timestamp to timestamptz for PG 7.3 (need to keep

time zone timestamps so dumps from PG 7.2 installs will still work)

Options
    • -6
    • +6
    ./content-item.sql
  2. … 18 more files in changeset.
Thursday 27 Feb 2003
2:44 pm

jeffd

register_child_type would only register one type per parent since it

ignored relation tag when checking if the relation existed.

is_valid_type failed with more than one type since it wanted to count

max_n but did not sum.

needs an upgrade script.

Options
    • -2
    • +2
    ./content-item.sql
  2. … 4 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -5
    • +5
    ./content-item.sql
  2. … 54 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -5
    • +5
    ./content-item.sql
  2. … 54 more files in changeset.
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
  2. … 3 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
  2. … 3 more files in changeset.
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.
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
    • -3
    • +1
    ./content-item.sql
  2. … 18 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

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

Options
    • -41
    • +19
    ./content-item.sql
  2. … 62 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
    • -7
    • +7
    ./content-item.sql
  2. … 61 more files in changeset.
Tuesday 23 Oct 2001
9:41 pm

donb

Dave Bauer's patches ...

Options
    • -167
    • +5
    ./content-item.sql
  2. … 1 more file in changeset.
Friday 28 Sep 2001
12:48 am

danw

added support for multiple file storage areas

Options
    • -1
    • +162
    ./content-item.sql
  2. … 11 more files in changeset.
Wednesday 05 Sep 2001
2:09 am

danw

fixed definition of item relationships

Options
    • -2
    • +2
    ./content-item.sql
Thursday 30 Aug 2001
6:01 am

danw

fixed insertion order for insert statement in content_revision__copy routine

Options
    • -2
    • +2
    ./content-item.sql
  2. … 1 more file in changeset.
3:46 am

danw

fixed image upload using lobs and file storage in CR

Options
    • -4
    • +6
    ./content-item.sql
  2. … 5 more files in changeset.
Tuesday 28 Aug 2001
3:07 am

danw

modified content_item__get_path to match oracle version

Options
    • -87
    • +189
    ./content-item.sql
Saturday 25 Aug 2001
4:22 pm

danw

removed circular dependency due to workflow

Options
    • -32
    • +38
    ./content-item.sql
  2. … 4 more files in changeset.
Friday 24 Aug 2001
12:50 am

danw

fixed get_path to match oracle version

Options
    • -84
    • +74
    ./content-item.sql
Thursday 23 Aug 2001
4:26 am

danw

fixed exception message in content_type__drop_attribute

Options
    • -1
    • +3
    ./content-item.sql
  2. … 2 more files in changeset.
Tuesday 17 Jul 2001
1:46 am

danw

patch supplied by Dave Bauer to pass in security_inherit_p flag when creating new content_item. Work-around for data-change violation

Options
    • -1
    • +165
    ./content-item.sql
Friday 06 Jul 2001
2:23 am

danw

workaround for content_item__delete problem related to pg RI problems

Options
    • -2
    • +2
    ./content-item.sql
Thursday 14 Jun 2001
2:23 am

danw

various bugfixes

Options
    • -17
    • +3
    ./content-item.sql
  2. … 4 more files in changeset.
Saturday 09 Jun 2001
3:06 am

danw

more cleanup

Options
    • -3
    • +3
    ./content-item.sql
  2. … 7 more files in changeset.
Friday 08 Jun 2001
3:52 am

danw

fixed a few pl/sql procs

Options
    • -0
    • +0
    ./content-item.sql
  2. … 2 more files in changeset.
Thursday 07 Jun 2001
2:04 am

danw

fixed tree query

Options
    • -2
    • +2
    ./content-item.sql
Sunday 13 May 2001
3:55 am

danw

moved content repository job scheduling from oracle to aolsrver, that it is compatible with postgresql

Options
    • -2
    • +1
    ./content-item.sql
  2. … 4 more files in changeset.