rel-segments-body-create.sql

  • last updated 5 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

    • -62
    • +124
    ./rel-segments-body-create.sql
  1. … 54 more files in changeset.
fix the static cvs-id tags

  1. … 32 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.
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

  1. … 598 more files in changeset.
Migrated the 4.6.1 permissions stuff to HEAD

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

  1. … 54 more files in changeset.
fixes to get dotlrn postgres port working

  1. … 4 more files in changeset.
added rel_segment__new function that takes only the parameters that don't have default values

added tcl variable support to db api

  1. … 3 more files in changeset.
partial fix of rel_constraints tree queries - more work required

  1. … 1 more file in changeset.
added comments for default api values

  1. … 12 more files in changeset.
more cleanup

  1. … 6 more files in changeset.
fixed up for loops

  1. … 3 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
    • +158
    ./rel-segments-body-create.sql
  1. … 37 more files in changeset.