• last updated 6 hours ago
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


- 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.
Backed out change to make content richtext rather than text, because of

xotcl-core, can't have the type change depending on whether or not that

was previously installed and can't change it to richtext without (probably)

breaking xotcl stuff. Sucks but that's life.

  1. … 3 more files in changeset.
Argh! "content" wants to be richtext, not text !!!

  1. … 4 more files in changeset.
Adding a couple of attributes to make packages working with meta-data less

kludgey. PG-only with this commit, Oracle to follow.

  1. … 2 more files in changeset.
Removing wrong acs attributes for object type apm_package.

Fixing object attribute datatypes so they are consistent

with the database datatype.

  1. … 3 more files in changeset.

Changed the representation of tree_sortkeys from "text" to "bit varying".

  1. … 62 more files in changeset.
added name method support for content_revision type

  1. … 5 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.
added tree queries

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

    • -0
    • +561
  1. … 7 more files in changeset.