Thanks Tom
create table fish
(
fish char(4)
)
select oid, * from pg_class where relname = 'fish'
4289092798
select max(oid) from pg_class
4289092798
Looks like it has not wrapped. Should I have the housekeeping cluster the
tables after I vacuum?
Thanks
Andrew
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Andrew Bartley" <abartley@evolvosystems.com>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, November 25, 2002 9:07 AM
Subject: Re: [GENERAL] Cluster problem
> "Andrew Bartley" <abartley@evolvosystems.com> writes:
> > This error pops up every few days during clustering
> > ERROR: Cannot insert a duplicate key into unique index
pg_class_oid_index
>
> Hmm, is it possible that your OID counter has wrapped around? Try
> creating a new table, and then look to see if its OID is the largest one
> in pg_class or not.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
