Re: Order of update

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Order of update
Date: 2025-04-20 14:28:34
Message-ID: CANzqJaBZypypH7uQzcBEvZqA+GOusk6SxicY7u6WPNeENWLWxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Apr 20, 2025 at 5:35 AM Thiemo Kellner <thiemo(at)gelassene-pferde(dot)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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2025-04-20 14:52:25 Re: Order of update
Previous Message Thiemo Kellner 2025-04-20 14:03:43 Re: Order of update