madisoncounty=# select ctid,xmin,xmax,cmin,cmax,usename from pg_shadow; ctid | xmin | xmax | cmin | cmax | usename -------+------+------+------+------+--------------- (0,1) | 1 | 596 | 596 | 1 | postgres (0,2) | 2 | 1 | 1 | 0 | postgres (0,5) | 2 | 0 | 0 | 0 | madisoncounty (3 rows) Tom Lane wrote:
Adam Dear <adear@xxxxxxxx> writes:The record is still there.Hmph. Could we see all the system columns from that table? select ctid,xmin,xmax,cmin,cmax,usename from pg_shadow; regards, tom lane