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