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

    • -164
    • +197
    ./rel-constraints-test.sql
    • -56
    • +92
    ./rel-segments-test-types-create.sql
  1. … 50 more files in changeset.
more cleanup of nullable strings in kernel

  1. … 8 more files in changeset.
fixed up some tree queries

  1. … 3 more files in changeset.
finished porting test-harness code

    • -21
    • +20
    ./rel-segments-test-types-create.sql
  1. … 4 more files in changeset.
added postgresql specific test files

    • -0
    • +311
    ./acs-objects-test.sql
    • -0
    • +170
    ./groups-test.sql
    • -0
    • +363
    ./rel-constraints-test.sql
    • -0
    • +205
    ./rel-segments-test-types-create.sql
    • -0
    • +14
    ./rel-segments-test-types-drop.sql
    • -0
    • +377
    ./rel-segments-test.sql
  1. … 2 more files in changeset.