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

journal-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 07 Jul 11
Commits this week: 0
Total Lines of Code (LoC): 189
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 42 mins 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
    • -40
    • +68
    ./journal-create.sql
  2. … 54 more files in changeset.
Monday 25 Sep 2006
7:59 pm

byronl

Correction of name constraint

Options
    • -3
    • +3
    ./journal-create.sql
  2. … 13 more files in changeset.
Friday 18 Jun 2004
8:21 pm

jeffd

fix the static cvs-id tags

Options
    • -1
    • +1
    ./journal-create.sql
  2. … 32 more files in changeset.
Friday 12 Mar 2004
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -1
    • +4
    ./journal-create.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -4
    • +1
    ./journal-create.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -1
    • +4
    ./journal-create.sql
  2. … 96 more files in changeset.
Saturday 17 May 2003
3:46 am

donb

Merged with 4.6 branch

Options
    • -1
    • +1
    ./journal-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
    • -1
    • +1
    ./journal-create.sql
  2. … 53 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -1
    • +1
    ./journal-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
    • -1
    • +1
    ./journal-create.sql
  2. … 54 more files in changeset.
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
    • -5
    • +5
    ./journal-create.sql
  2. … 23 more files in changeset.
Wednesday 18 Apr 2001
1:41 am

danw

added comments for default api values

Options
    • -6
    • +6
    ./journal-create.sql
  2. … 12 more files in changeset.
Wednesday 14 Mar 2001
5:39 am

danw

initial import of acs kernel data-model ported to postgresql - implementation of tree queries completed for acs_object_types. Still need to finish tree queries for acs_privilege_hierarchy and rel_constraints tables.

Options
    • -0
    • +158
    ./journal-create.sql
  2. … 37 more files in changeset.