• last updated 6 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.
Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

  1. … 721 more files in changeset.
Fixed "bug" #2747. The code was never called and was just a stub that

hadn't been ported to PG, but I removed it so future people with

sharp eyes don't look at it and report the "bug" again.

merge of 4.6.3b1 to HEAD

  1. … 101 more files in changeset.
Partial conversion from timestamp to timestamptz for PG 7.3 (need to keep

time zone timestamps so dumps from PG 7.2 installs will still work)

  1. … 18 more files in changeset.
catchall

  1. … 2 more files in changeset.
moved content repository job scheduling from oracle to aolsrver, that it is compatible with postgresql

  1. … 4 more files in changeset.

Removed more of the "default '' not null" kludge.

  1. … 18 more files in changeset.
partial work on content-test

  1. … 10 more files in changeset.
fixed up content-repository code so that it will load. Dynamic trigger code commented out for now

  1. … 13 more files in changeset.
general cleanup of initial porting effort

  1. … 11 more files in changeset.
initial port to postgresql

    • -0
    • +160
    ./content-schedule.sql