On Mon, Aug 17, 2009 at 6:17 PM, Tom Lane<t...@sss.pgh.pa.us> wrote: > Bryan Murphy <bmurphy1...@gmail.com> writes: >> Here's the xmin/xmax/ctid for three problematic records: > >> prodpublic=# select xmin,xmax,ctid from items_extended where id in >> ('34537ed90d7546d78f2c172fc8eed687', '3e1d99b7124742b7aaf2f869f7637b0e', >> '499b464f141a48619c5ce0475cbe9150'); >> xmin | xmax | ctid >> -----------+-----------+------------ >> 262232659 | 308810030 | (689496,3) >> 262629744 | 308810034 | (692765,1) >> 262643188 | 308810035 | (692920,9)
Hm, perhaps I should have asked for xvac as well, as that can also trigger an "invisible" status. You can't select xvac directly but if you query cmin it might be possible to tell what's going on. -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general