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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Bartley" <abartley(at)evolvosystems(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, November 25, 2002 9:07 AM
Subject: Re: [GENERAL] Cluster problem

> "Andrew Bartley" <abartley(at)evolvosystems(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>