On Mon, Aug 01, 2016 at 12:48:57PM -0400, Rakesh Kumar wrote: > Can an existing stored procedure be modified online while other users > are executing it. In Oracle, the session doing CREATE OR REPLACE > PACKAGE would wait for other session to complete. Once the package is > changed, first time other sessions will get an error "package > invalidated". How is it in PG. If you Read The Fine Manual https://www.postgresql.org/docs/devel/static/index.html I am pretty sure there's something about DDL transactibility related to CREATE FUNCTION https://www.postgresql.org/docs/devel/static/sql-createfunction.html In particular, by extension, the example way at the bottom seems relevant to your question. Regards, Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
