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: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 1,722
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 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 22 Sep 2003
1:52 pm

lars

Applied patch #280 for bug #820

Options
    • -2
    • +2
    ./acs-objects-create.sql
  2. … 1 more file in changeset.
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -10
    • +16
    ./acs-objects-create.sql
  2. … 816 more files in changeset.
Monday 25 Aug 2003
11:40 pm

donb

Corrected PG version of Barry Brooks speed up to the object update trigger,

added the new Oracle trigger to the proper upgrade script.

Options
    • -2
    • +2
    ./acs-objects-create.sql
  2. … 2 more files in changeset.
Sunday 24 Aug 2003
2:27 am

donb

Modified Barry Brooks's context_id update trigger speedup for PostgreSQL,

did some testing ...

Options
    • -7
    • +11
    ./acs-objects-create.sql
  2. … 1 more file in changeset.
Monday 23 Jun 2003
8:47 pm

janines

add user id and IP address to update_last_modified()

Options
    • -10
    • +16
    ./acs-objects-create.sql
  2. … 10 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -8
    • +11
    ./acs-objects-create.sql
  2. … 30 more files in changeset.
Sunday 02 Mar 2003
11:32 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -8
    • +8
    ./acs-objects-create.sql
  2. … 53 more files in changeset.
Tuesday 18 Feb 2003
9:53 pm

donb

Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

Options
    • -24
    • +26
    ./acs-objects-create.sql
  2. … 17 more files in changeset.
Monday 17 Feb 2003
4:32 pm

jeffd

rollback Dons commit which should have gone in on 4.6 rather than HEAD

Options
    • -24
    • +16
    ./acs-objects-create.sql
  2. … 7 more files in changeset.
Friday 14 Feb 2003
3:47 am

donb

More mucking around with the denormalized party_approved_member_map ...

Options
    • -16
    • +24
    ./acs-objects-create.sql
  2. … 7 more files in changeset.
Thursday 13 Feb 2003
11:30 pm

jeffd

delete direct permissions in acs_object__delete (oracle and postgres) upgrade provided, bug 234 patch 74 Tilmann Singer

Options
    • -0
    • +3
    ./acs-objects-create.sql
  2. … 3 more files in changeset.
Tuesday 11 Feb 2003
6:03 pm

donb

1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

Options
    • -20
    • +26
    ./acs-objects-create.sql
  2. … 23 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -5
    • +3
    ./acs-objects-create.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
    • +3
    ./acs-objects-create.sql
  2. … 54 more files in changeset.
Monday 29 Jul 2002
5:52 am

chak

fixed a query that used select instead of perform

Options
    • -1
    • +1
    ./acs-objects-create.sql
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