OpenACS / openacs-4 / packages / acs-kernel / sql / postgresql

acs-objects-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 16
Last Commit: 27 Dec
Commits this week: 0
Total Lines of Code (LoC): 1,438
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
Saturday 22 Jun 2002
11:26 pm

yon

postgres does not like a certain flavor of table aliases

Options
    • -5
    • +5
    ./acs-objects-create.sql
Wednesday 19 Jun 2002
9:42 pm

yon

adding variation on function

Options
    • -0
    • +8
    ./acs-objects-create.sql
Saturday 25 May 2002
4:05 pm

yon

forgot to pass last_modified in recursive call

Options
    • -1
    • +1
    ./acs-objects-create.sql
4:00 pm

yon

created acs_object.update_last_modified procedure that takes in an object_id

and an optional timestamp and sets the last_modified time of the object and

all of it's parents (not including object 0) to the last_modified time passed

in or sysdate if none was passed in.

Options
    • -0
    • +28
    ./acs-objects-create.sql
  2. … 1 more file in changeset.
Wednesday 13 Mar 2002
11:50 pm

donb

Merged with OpenACS 4.5 beta1 branch.

Options
    • -2
    • +7
    ./acs-objects-create.sql
  2. … 88 more files in changeset.
Sunday 10 Mar 2002
12:34 am

donb

1. Community core change was due to an earlier patch that allows a person

to register as a user.

2. Deleting an acs-object would fail if the object specific table didn't exist.

acs-objects and the content repository shouldn't require type specific tables

be named when you extend a type, this is a temporary hack which acknowledges

that folks have been cheating by name non-existent tables. Since I plan to

remove the restriction anyway, this is not a big deal.

The Oracle version still needs testing ...

Options
    • -2
    • +7
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Sunday 27 Jan 2002
1:19 am

ben

fixed an efficiency issue in removing objects

Options
    • -1
    • +5
    ./acs-objects-create.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
    • -63
    • +9
    ./acs-objects-create.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
    • -20
    • +16
    ./acs-objects-create.sql
  2. … 62 more files in changeset.
Friday 07 Dec 2001
10:59 pm

ben

made /pvt/home configurable

Options
    • -2
    • +16
    ./acs-objects-create.sql
  2. … 3 more files in changeset.
Saturday 01 Dec 2001
6:55 pm

donb

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

Options
    • -8
    • +5
    ./acs-objects-create.sql
  2. … 11 more files in changeset.
Thursday 11 Oct 2001
6:03 am

danw

added acs_object__new which takes security_inherit_p as an arguement. Needed for static pages

Options
    • -0
    • +36
    ./acs-objects-create.sql
Saturday 01 Sep 2001
10:26 pm

donb

Install acs-service-contract ...

Options
    • -1
    • +1
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Friday 06 Jul 2001
2:19 am

danw

fixed acs_objects__get_attribute so that it works with all return types. Problems were encountered with returning integer and timestamp types

Options
    • -2
    • +2
    ./acs-objects-create.sql
Tuesday 03 Jul 2001
2:09 am

danw

fixed return type of acs_object__get_attribute so that timestamps can be returned

Options
    • -1
    • +1
    ./acs-objects-create.sql
Saturday 28 Apr 2001
7:35 pm

donb

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

Options
    • -7
    • +13
    ./acs-objects-create.sql
  2. … 23 more files in changeset.
Thursday 19 Apr 2001
3:17 am

danw

more strict string handling changes

Options
    • -1
    • +1
    ./acs-objects-create.sql
  2. … 4 more files in changeset.
Wednesday 18 Apr 2001
1:41 am

danw

added comments for default api values

Options
    • -8
    • +8
    ./acs-objects-create.sql
  2. … 12 more files in changeset.
Saturday 14 Apr 2001
7:12 am

danw

more cleanup of nullable strings in kernel

Options
    • -4
    • +4
    ./acs-objects-create.sql
  2. … 8 more files in changeset.
Sunday 08 Apr 2001
6:13 pm

danw

fixed acs_object tree trigger

Options
    • -1
    • +2
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Wednesday 04 Apr 2001
1:59 am

danw

more debugging of test script

Options
    • -1
    • +1
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Friday 23 Mar 2001
1:21 am

danw

finished porting test-harness code

Options
    • -19
    • +37
    ./acs-objects-create.sql
  2. … 8 more files in changeset.
Wednesday 21 Mar 2001
7:41 am

danw

fixed a couple of dynamic sql statements

Options
    • -10
    • +12
    ./acs-objects-create.sql
6:46 am

danw

fixed exception messages, membership_rels delete trigger and composition_rels delete trigger

Options
    • -18
    • +19
    ./acs-objects-create.sql
  2. … 5 more files in changeset.
Tuesday 20 Mar 2001
7:02 am

danw

more cleanup

Options
    • -15
    • +25
    ./acs-objects-create.sql
  2. … 6 more files in changeset.
5:20 am

danw

removed more debug code

Options
    • -1
    • +1
    ./acs-objects-create.sql
5:14 am

danw

removed debug code

Options
    • -19
    • +19
    ./acs-objects-create.sql
5:12 am

danw

fixed several name conflicts

Options
    • -31
    • +37
    ./acs-objects-create.sql
  2. … 3 more files in changeset.
Monday 19 Mar 2001
6:07 am

danw

fixed name conflicts with for loop records

Options
    • -29
    • +25
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Sunday 18 Mar 2001
6:22 am

danw

fixed up a bunch of typos

Options
    • -6
    • +6
    ./acs-objects-create.sql
  2. … 8 more files in changeset.