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 по дате отправления:

Предыдущее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses
Следующее
От: Siddharth Jain
Дата:
Сообщение: could not bind IPv4 address "127.0.0.1": Address already in use