SET WITHOUT OIDS and VACUUM badness?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: SET WITHOUT OIDS and VACUUM badness?
Date: 2004-01-21 08:08:07
Message-ID: 400E3367.1030906@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This is what we did:

0. BEGIN;

1. ALTER TABLE ... SET WITHOUT OIDS

2. A bunch of things are selected out of this table and inserted into
another (using INSERT ... SELECT)

3. An index is created on a timestamp field on this table

4. Then there's an update on a related table, that selects stuff from
this table.

5. Renames a column

6. Drops a constraint

7. Adds a foreign key

8. Drops 8 columns

9. Drops 2 indexes

10. Drops 3 triggers

11. Then a tsearch 'txtidx' field is updated, and then cancelled halfway
through

12. ROLLBACK;

13. VACUUM FULL forums_posts;

Then we get thousands of these:

WARNING: relation "forums_posts" TID 22763/10: OID is invalid
WARNING: relation "forums_posts" TID 22763/11: OID is invalid
WARNING: relation "forums_posts" TID 22763/12: OID is invalid
WARNING: relation "forums_posts" TID 22763/13: OID is invalid
WARNING: relation "forums_posts" TID 22763/14: OID is invalid
WARNING: relation "forums_posts" TID 22763/15: OID is invalid
WARNING: relation "forums_posts" TID 22763/16: OID is invalid
WARNING: relation "forums_posts" TID 22763/17: OID is invalid
WARNING: relation "forums_posts" TID 22764/1: OID is invalid
WARNING: relation "forums_posts" TID 22764/2: OID is invalid
WARNING: relation "forums_posts" TID 22764/3: OID is invalid
WARNING: relation "forums_posts" TID 22764/4: OID is invalid

This seems to be reproducible...

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dennis Bjorklund 2004-01-21 10:03:02 Re: SET WITHOUT OIDS and VACUUM badness?
Previous Message Alex 2004-01-21 05:25:23 Re: SQL Exception Relation xxx does not exist