Content-Repository Reform : Reduction of number of functions in the content repository for PostgreSQL by using using argument defaults (while providing compatibility for clients using old versions): - reduced number of versions of content_item__new from 12 (!) to 6 by using defaults - commented differences - commented arguments of plpgsql functions with long argument lists - reduced code duplication by basing one version of content_item__new/17 directly on /20 - marking on version of content_item__new/17 and content_item__new/6 as deprecated
- reduced number of versions of content_revision__new from 7 to 4 by using defaults - commented differences - marking on version of content_revision__new/7 as deprecated - let automatically generated functions call directly content_revision__new/13 - remove space from automatically generated functions - updated automatically generated functions for all types of the content repository
- reduced number of versions of image__new from 4 to 2by using defaults - reduced number of versions of image__new_revision from 2 to 1 by using defaults
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