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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
Дата
Msg-id CAKFQuwaihWfF9U1LvZMg3DQiXS55Rk2KA-HH1bUVPstpsdza1Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-general
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 по дате отправления: