Re: Cluster problem
От | Andrew Bartley |
---|---|
Тема | Re: Cluster problem |
Дата | |
Msg-id | 001801c29408$1f1feb70$3200a8c0@abartleypc обсуждение исходный текст |
Ответ на | Error Occurred when run function. How to solve it? ("annachau" <annachau@hongkong.com>) |
Ответы |
Re: Cluster problem
|
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления: