Re: Cluster problem

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
>
>