Can stored procedures be deployed online

From: Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Can stored procedures be deployed online
Date: 2016-08-01 16:48:57
Message-ID: CAJBB=EU4F2_xUhVRhRqucxyqeDy-MyCxvmM6SfvcK6476Ftsgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2016-08-01 17:29:45 Re: Can stored procedures be deployed online
Previous Message Andrew Geery 2016-08-01 16:48:19 consolidating data with window functions