Thread: Can stored procedures be deployed online

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.

thanks.

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