Re: [GENERAL] Can stored procedures be deployed online

2016-08-01 Thread Karsten Hilbert
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

[GENERAL] Can stored procedures be deployed online

2016-08-01 Thread Rakesh Kumar
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.