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.96) (envelope-from ) id 1vY0u9-00BnLX-0x for pgsql-docs@arkaria.postgresql.org; Tue, 23 Dec 2025 11:50:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vY0u8-001HYZ-0M for pgsql-docs@arkaria.postgresql.org; Tue, 23 Dec 2025 11:50:16 +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.96) (envelope-from ) id 1vY0u7-001HYR-2m for pgsql-docs@lists.postgresql.org; Tue, 23 Dec 2025 11:50:16 +0000 Received: from mail-yx1-xb136.google.com ([2607:f8b0:4864:20::b136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vY0u7-002B2b-1G for pgsql-docs@lists.postgresql.org; Tue, 23 Dec 2025 11:50:15 +0000 Received: by mail-yx1-xb136.google.com with SMTP id 956f58d0204a3-64669a2ecb5so4476782d50.1 for ; Tue, 23 Dec 2025 03:50:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1766490614; x=1767095414; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=SOA8kUGEGD9VQwir4c239L+K103ZCNEyt3BvFdbHIYQ=; b=kSwrDVIC+5yaT4pSVkUYL89e53sCPI4JpCgTFi5hHOgxSL7REhlXiK9TuNFM0bjHUw 12DQzC8GC5yYFYkFqZZiRZlEEWhXLwIYFWfIdVGG2VU+M5SwrMAN1pGjrK2dYMZu+x1w RKLPIpwkj9vZqIwpIXJAwVO198e7uaGs4Ao52B1W909Wfio0l56Zn19ZzEcFfgC042TI 3wRlC1eNOzv2nPoqPz/TIY052TXiCKYS+VzZ5E0S2jaMgKE8eZhRBxgafrHyEmkSb6Hx Uy40bqT+uCqMEle3Cd71MNXvbkNGuSZAtmW6iSXwXEbVKlwC0W2vflrTirItbya3OSFZ Q9iw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1766490614; x=1767095414; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=SOA8kUGEGD9VQwir4c239L+K103ZCNEyt3BvFdbHIYQ=; b=D/ESwu16i912IScSOjPF6HCEuXyBVs35d1VrjyZiWy5b2JROozPCOSU20Vbd2a04+f +Pn8TeDBsuRK2NF545oszEQbNgVk9lMvf9ye+exR8odAgLJ36KNTeI0YQewqvy9mf4f+ 3oUVQH9KQ+qqqToaS2RERsKaPezWIqseqnytxG91Py22QpBebMXfIr2DIcAGo6+FrKdH M1ryDQ0teG4vBGnD6Ybe2g2pzP5cwe24qm9+G7GddpwlTWmF1SlVYKVHY5VqduHBx7fl jDK80fVZMQOkzEDUqo3h8ZRHEO8OtoSUyBVK0h+/OFkwJzg9W5OI+sIXRq5m7/sXI+wz +lUg== X-Gm-Message-State: AOJu0Yy6+kjbxVt4Cv3h9HQdUYN1Kzttsvm0qfIrObyqmMXZ9KGsC/aC KbaJgl5pjwLQEW65Fd70P41bejIa4orIJKaotdCsUfGQ6Ppd3+Mn4ZMDNeu25NefuzD9L84xwv9 G3gx4s3q21K+fSIibFJS5i+eOwsMgoPs= X-Gm-Gg: AY/fxX4l8dGM1sTPzyw/f+33cCyy/e51a6wU1NZKs4nkQMq2myMi9QYD5aJ1HO+BJw9 GJkvueQMio4ivJ9RnGc0FXyJjn88T+mxo+NchnWzwWNmjnOevQ668fdDPiztWhSWhgOtb2Xj03Z GOYhGyoi7y/wI5cxTzs1UMXVrmG+Yfkw+XHA2La650pXUwSBHYDgSF1a3fyr/0H95QHC4dXE1sm 0CyhwxVrf2JIfPvmRuyDno+d9uHG0z/+y+Dr11LRrQ3NiZVr40CWPzy0AbniKyxYDndMZPhaWLn Fmwcu+IZ6e+rYWUzK5t2 X-Google-Smtp-Source: AGHT+IHghmC19JAkH4yUeeUVfgKcUguc3frW0FjE4JqNcoWUadxJT+4g41KDm8dOo8FsOO1l7V5UOQ5ZNDLBS+7oDrY= X-Received: by 2002:a05:690e:134f:b0:646:5127:a024 with SMTP id 956f58d0204a3-646632275b8mr14390386d50.7.1766490613794; Tue, 23 Dec 2025 03:50:13 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Bernice Southey Date: Tue, 23 Dec 2025 11:49:37 +0000 X-Gm-Features: AQt7F2optzNWnBvgF6M18cX3VgGMWdVKiaVdjfpdN_pqtxpAFHxtetayNzisYaI Message-ID: Subject: Re: More guidance on ctid To: Bruce Momjian Cc: pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Bruce Momjian wrote: > What I did do was to explain why ctid was safe in this > use-case. I also strengthened the documentation that ctid is not valid > for row references. I like this, explaining the risk is much better. I couldn't think of a simple way to do it. There was a strong preference for not duplicating the explanatory text when the examples were added. Perhaps delete doesn't need the new line? Thanks, Bernice PS - Thanks for your postgres internals videos. I found them a few months ago and they lit up my brain.