Re: Can stored procedures be deployed online

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