Re: Order of update

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Order of update
Дата
Msg-id CANzqJaBZypypH7uQzcBEvZqA+GOusk6SxicY7u6WPNeENWLWxw@mail.gmail.com
обсуждение исходный текст
Ответ на Order of update  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Ответы Re: Order of update
Список pgsql-general
On Sun, Apr 20, 2025 at 5:35 AM Thiemo Kellner <thiemo@gelassene-pferde.biz> wrote:
Very interesting. But is the sort overhead worth it? Why not make the constraint deferrable before the update and switch back afterwards?

The role which runs the UPDATE might not have the priv to ALTER TABLE ... ALTER CONSTRAINT. 

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

В списке pgsql-general по дате отправления: