authentication-package-create.sql

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

    • -47
    • +49
    ./authentication-package-create.sql
  1. … 54 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.
committed the authority__new function with more than 16 arguments which doesn't work in PG. Reverting back to 16 args

    • -15
    • +5
    ./authentication-package-create.sql
  1. … 4 more files in changeset.
making sort order default to the current highest sort order plus one for authorities

    • -2
    • +10
    ./authentication-package-create.sql
  1. … 3 more files in changeset.
adding batch sync related columns to the auth_authorities table

    • -5
    • +15
    ./authentication-package-create.sql
  1. … 6 more files in changeset.
Support for external authentication: two new columns added to users table - username and authority. New object type authority with corresponding table auth_authorities. Bumping version number to 5.0d3

    • -0
    • +85
    ./authentication-package-create.sql
  1. … 16 more files in changeset.