• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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

  1. … 54 more files in changeset.
switch foo_id_seq.netval to nextval('t_foo_id_seq') calls to placate postgresql 8.

  1. … 8 more files in changeset.
Correction of name constraint

  1. … 13 more files in changeset.
fix the static cvs-id tags

  1. … 32 more files in changeset.
Merged with 4.6 branch

  1. … 30 more files in changeset.
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 ...

  1. … 53 more files in changeset.

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...

  1. … 23 more files in changeset.
more cleanup of nullable strings in kernel

  1. … 8 more files in changeset.
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.

    • -0
    • +119
    ./acs-logs-create.sql
  1. … 37 more files in changeset.