Re: contrib/pgcrypto functions not IMMUTABLE? - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: contrib/pgcrypto functions not IMMUTABLE?
Date
Msg-id 20050704022724.GA60666@winnie.fuhr.org
Whole thread Raw
In response to Re: contrib/pgcrypto functions not IMMUTABLE?  (Neil Conway <neilc@samurai.com>)
Responses Re: contrib/pgcrypto functions not IMMUTABLE?
List pgsql-hackers
On Mon, Jul 04, 2005 at 11:42:14AM +1000, Neil Conway wrote:
> 
> Assuming the STRICT / IMMUTABLE changes are only going into HEAD, you 
> can safely remove the PG_ARGISNULL() checks -- people upgrading from a 
> prior version of Postgres (and therefore pgcrypto) will need to dump and 
> reload anyway.

But if they restore a dump made with pg_dump or pg_dumpall, they'll
get the old catalog entries sans STRICT, no?  People might rebuild
the module when they upgrade, but they might not think to drop and
recreate the functions since the definitions are already in the
dump.  I suppose the Release Notes could mention that recreating
the functions is required; it could also show the SQL statements
necessary to update pg_proc so a drop/recreate wouldn't be necessary.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: contrib/pgcrypto functions not IMMUTABLE?
Next
From: Neil Conway
Date:
Subject: Re: contrib/pgcrypto functions not IMMUTABLE?