Re: More guidance on ctid

2025-11-24 Thread Bruce Momjian
On Sun, Nov 23, 2025 at 10:24:42AM +, Bernice Southey wrote: > Hi, > I'm wondering if the explanation of ctid in System Columns should have > more guidance - especially as it's used in examples in the UPDATE and > DELETE docs. So far I've been caught out by partitions and concurrent > updates.

More guidance on ctid

2025-11-23 Thread Bernice Southey
Hi, I'm wondering if the explanation of ctid in System Columns should have more guidance - especially as it's used in examples in the UPDATE and DELETE docs. So far I've been caught out by partitions and concurrent updates. This was after I changed primary keys to ctid, in self-joins that get ORDER