Thread: pgsql: This patch updates the DDL for contrib/pgcrypto to create all

pgsql: This patch updates the DDL for contrib/pgcrypto to create all

From

neilc@svr1.postgresql.org (Neil Conway)

Date:

08 July 2005, 01:28:02

Log Message:
-----------
This patch updates the DDL for contrib/pgcrypto to create all
functions as STRICT, and all functions except gen_salt() as IMMUTABLE.
gen_salt() is VOLATILE.

Although the functions are now STRICT, I left their PG_ARGISNULL()
checks in place as a protective measure for users who install the
new code but use old (non-STRICT) catalog entries (e.g., restored
from a dump).  Per recent discussion in pgsql-hackers.

Patch from Michael Fuhr.

Modified Files:
--------------
    pgsql/contrib/pgcrypto:
        pgcrypto.sql.in (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/pgcrypto.sql.in.diff?r1=1.9&r2=1.10)