Postgres Pro
Downloads
Home   >   mailing lists

Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses - Mailing list pgsql-general

From David G. Johnston
Subject Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
Date
Msg-id CAKFQuwaihWfF9U1LvZMg3DQiXS55Rk2KA-HH1bUVPstpsdza1Q@mail.gmail.com
Whole thread Raw
In response to Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses  (Bryn Llewellyn <bryn@yugabyte.com>)
List pgsql-general
Tree view
On Tue, Mar 7, 2023 at 5:52 PM Bryn Llewellyn <bryn@yugabyte.com> wrote:

Regard a DDL on any object that an application uses as unsafe while the app is in use. You must terminate all client-sessions before doing such a DDL and re-start them only when all such DDLs are done successfully.


No.  If you simply "ADD COLUMN" to an existing table the "terminate all client-sessions" action is excessive, IMO.

David J.

pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
Next
From: Siddharth Jain
Date:
Subject: could not bind IPv4 address "127.0.0.1": Address already in use