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

content-util.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 4
Last Commit: 02 May
Commits this week: 0
Total Lines of Code (LoC): 123
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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • -31
    • +79
    ./content-util.sql
  2. … 54 more files in changeset.
Monday 17 Sep 2007
2:58 pm

maltes

Got rid of reliance on Java for Oracle. Removed unused old functions. Hopefully someone else can help with a fresh install test as well

Options
    • -71
    • +1
    ./content-util.sql
  2. … 5 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
    • -12
    • +12
    ./content-util.sql
  2. … 598 more files in changeset.
Wednesday 23 May 2001
12:46 am

danw

finished cleanup of data-model, it now loads without errors

Options
    • -2
    • +2
    ./content-util.sql
  2. … 8 more files in changeset.
Sunday 01 Apr 2001
7:57 am

danw

I relealized that the dynmic trigger code wouldn't work as the trigger is actually being applied to a view. Changed code to use a rule instead, and now everything seems to work. More evaluation required however.

Options
    • -1
    • +13
    ./content-util.sql
  2. … 1 more file in changeset.
Saturday 31 Mar 2001
7:12 am

danw

fixed up dynamic trigger creation for new content types

Options
    • -23
    • +34
    ./content-util.sql
  2. … 1 more file in changeset.
Friday 30 Mar 2001
7:31 am

danw

fixed up content-repository code so that it will load. Dynamic trigger code commented out for now

Options
    • -3
    • +1
    ./content-util.sql
  2. … 13 more files in changeset.
Wednesday 28 Mar 2001
4:15 am

danw

general cleanup of initial porting effort

Options
    • -4
    • +4
    ./content-util.sql
  2. … 11 more files in changeset.
Sunday 25 Mar 2001
3:20 am

danw

initial port to postgresql

Options
    • -0
    • +124
    ./content-util.sql
  2. … 1 more file in changeset.