• 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.
add define_function_args definitions for most functions, bump to 5.2.0d5, upgrade script

  1. … 9 more files in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

  1. … 97 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

  1. … 96 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

  1. … 96 more files in changeset.
PG 7.3 doesn't support 'current_timestamp' as a literal any more (it still

is defined as a variable, of course). Also define_function_args assumes

NULL as the default value if none is specified, 'null' <> NULL ...

  1. … 6 more files in changeset.
Added define_function_arg calls to non-content-revision objects and to

create_type and create_attributes, so we can do these operations via

Tcl. Content revisions, due to LOB/non-LOB issues and the incompatibility

of LOB operations between DBs need their own "smart" Tcl API.

  1. … 10 more files in changeset.
Added optional name parameter for copy functions.

  1. … 2 more files in changeset.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 101 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

  1. … 54 more files in changeset.
added file support to CR data-model

  1. … 12 more files in changeset.

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

  1. … 18 more files in changeset.
more strict string handling changes

  1. … 4 more files in changeset.
added comments for default parameters

  1. … 10 more files in changeset.
more debugging of test script and associated fixes

  1. … 3 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
    • +272
    ./content-symlink.sql
  1. … 1 more file in changeset.