Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6Vf8-00Gx0l-3c for pgsql-general@arkaria.postgresql.org; Sun, 20 Apr 2025 14:28:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6Vf5-00CIHz-To for pgsql-general@arkaria.postgresql.org; Sun, 20 Apr 2025 14:28:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6Vf5-00CIDK-F9 for pgsql-general@lists.postgresql.org; Sun, 20 Apr 2025 14:28:48 +0000 Received: from mail-oo1-xc35.google.com ([2607:f8b0:4864:20::c35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u6Vf4-0011yV-0W for pgsql-general@postgresql.org; Sun, 20 Apr 2025 14:28:47 +0000 Received: by mail-oo1-xc35.google.com with SMTP id 006d021491bc7-6049acb776bso1544256eaf.3 for ; Sun, 20 Apr 2025 07:28:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745159325; x=1745764125; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=AodOHjwaeMjfnd43hQ7hJ/mvLFCZz05KgHV6H+ouGh0=; b=lVh8+eylZIOsRdx771X4qw/9km0WkwBHrV6j65WeaO4ebBAklmGiAN06rx+m+LlTGT 4ojmeetha62tMN5lxFDNSatl1akaoBiByM4WWGWd/Alca3qzHXQZnE0d1+QnHWp/TckD axm5Srsz0lp0iwcqU7ymuz2o/paL6sQZ6cQ9/cSSVnc1CnpGLc95lo+vwkTyYhSLv7KY hSA0c+o+8s0cx/eAZzQda3O0UPOC9q7QQDGIjSkSOuxE125WMy8skAwz5ifTV9IiLA52 BDIwof+YZg5dEOURNwiAo4APP9hVB91yK3XzprAuLiKEiAX4JB0lZV+ymicnrbbd7edd iAIw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745159325; x=1745764125; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=AodOHjwaeMjfnd43hQ7hJ/mvLFCZz05KgHV6H+ouGh0=; b=hGmxfGVSHQU4BWNU20VSaISgtxNCWf2LyG2iqbeVkGBTy1TQyyww2kZipn16XXTjB4 fE/55OZYyAlBW48eU28pOsHEifTUvvDyEOBlnoyERONUjCfVW+uVVSe4TqAJoAsJt1NO XTiU4kBh3aUU1OUJfR+fyXb8+xXpw+tbynHI4iFC8aOaZ40Md6YIvsJxp/2m/p3bX9uX 14hHUgm+O9QCmf850tBZ3ZpYVRCVmhxci8neF5/03np5D/UdgLMGiP0gqE55oAbtV+61 Ens+kVsD2PWOuXHiLKniDeyZuGqXs9Ud5xl78x5AOT02Clf1uOetzhActKnHizT8+45g x31Q== X-Gm-Message-State: AOJu0Yz4XfdNskMZyn+HaNjlPb6T3pdHrbdC/r/isuc36GzsSR6WYVIP 5aC9zGQGFd36Eurmf76LjUrWr5Q7JBXiO28wIVS42nK3C1fvQdf3a/oR/FH0UoOGHSPfn1H2pTy i0Uhay77zDkgcTdC+evxIhI9VInsbWw== X-Gm-Gg: ASbGncsxzKRP8Kii7Ac9wfAS3xH6IsQ2Cw0t3+5lpNcjAArlOCuLGd3tKulz1tgz211 6/6qyiVpuN5wLvA2wGm4CIB4E3Wbqt41uTHEv6yAMBsTbIKR0NYKOM1kQ3ZMmOtcFaFt1BgXAlu devEZE2buH6NtCuxTM/9KynV/shUbzpK0OBUWr6R2iUNXAOcPxBbrSgA== X-Google-Smtp-Source: AGHT+IH8ZOnpyvIzltAxlm2YOZUSR2efpOnskSZbyZy8ryNw9ZNBrG+A7q7DSYlhk3E16K6G5U6Odf9TskrzS+niR2c= X-Received: by 2002:a05:6820:22a0:b0:602:5856:255c with SMTP id 006d021491bc7-606005e0517mr4534406eaf.8.1745159325224; Sun, 20 Apr 2025 07:28:45 -0700 (PDT) MIME-Version: 1.0 References: <20250420091033.n437fdrkihtjrncd@hjp.at> <277c713f-452c-4449-9897-16a9738077eb@gelassene-pferde.biz> In-Reply-To: <277c713f-452c-4449-9897-16a9738077eb@gelassene-pferde.biz> From: Ron Johnson Date: Sun, 20 Apr 2025 10:28:34 -0400 X-Gm-Features: ATxdqUFst44tWhDUHGPNS-AFIA804hb_1Mi1Ge70KkT-RadV0aURq0lfVIz45uc Message-ID: Subject: Re: Order of update To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000a8181406333691cb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a8181406333691cb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Apr 20, 2025 at 5:35=E2=80=AFAM Thiemo Kellner 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. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000a8181406333691cb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Apr 20, 2025 at 5:35=E2=80=AFAM T= hiemo Kellner <thiemo@gel= assene-pferde.biz> wrote:
Very interest= ing. But is the sort overhead worth it? Why not make the constraint deferra= ble before the update and switch back afterwards?

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

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