Dimitri Fontaine <dimi...@2ndquadrant.fr> writes: > Is there a test somewhere that when CREATE OR REPLACE FUNCTION > runs from an extension's script at upgrade, the function must > already be attached to the extension if it exists in the system? > Ditto for views etc?
IIRC, the current behavior is that C.O.R.F. on an existing function preserves the function's existing extension membership, if any. It doesn't matter whether you are doing it from an extension script or not. I'm not really eager to change that, and I doubt it would make any difference anyway to the use-case under consideration --- if the 1.0-to-1.1 script is adding a function, it's unlikely the function existed pre-1.0 ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers