Home > mailing lists

Re: Order of update - Mailing list pgsql-general

From	Ron Johnson
Subject	Re: Order of update
Date	April 20 17:28:34
Msg-id	CANzqJaBZypypH7uQzcBEvZqA+GOusk6SxicY7u6WPNeENWLWxw@mail.gmail.com Whole thread Raw
In response to	Order of update (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Responses	Re: Order of update
List	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!

From: Thiemo Kellner
Date: 20 April, 17:03:43
Subject: Re: Order of update

From: Thiemo Kellner
Date: 20 April, 17:52:25
Subject: Re: Order of update