I tried:

Vacuum Freeze pg_shadow;

Then

Reindex database madisoncounty;

Then

Delete from pg_shadow where ctid='(0,1)';


The record is still there.

Tom Lane wrote:
Adam Dear <[EMAIL PROTECTED]> writes:
I tried:
Delete from pg_shadow where ctid = '(0,1)';
DELETE 0

This is looking more and more like a transaction ID wraparound problem.
Did you try the vacuum freeze suggestion?

                        regards, tom lane



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to