Postgres Pro
Downloads
Home   >   mailing lists

Re: Error: duplicate key violates unique constraint - "pg_toast_3270368541_index - Mailing list pgsql-admin

From Tom Lane
Subject Re: Error: duplicate key violates unique constraint - "pg_toast_3270368541_index
Date
Msg-id 24681.1195105047@sss.pgh.pa.us
Whole thread Raw
In response to Error: duplicate key violates unique constraint - "pg_toast_3270368541_index  ("Tomeh, Husam" <HTomeh@facorelogic.com>)
Responses Re: Error: duplicate key violates unique constraint - "pg_toast_3270368541_index  ("Tomeh, Husam" <HTomeh@facorelogic.com>)
List pgsql-admin
Tree view 
"Tomeh, Husam" <HTomeh@facorelogic.com> writes:
> We've started getting duplicate key violates unique constraint error on
> one of the toast index starting last weekend.

> PG version is 8.0 with postgis extension.

Consider updating to something more recent.  That problem was
addressed in this 8.1-cycle patch:
http://archives.postgresql.org/pgsql-committers/2005-08/msg00109.php

            regards, tom lane

pgsql-admin by date:

Previous
From: "Tena Sakai"
Date:
Subject: Re: postgres bogged down beyond tolerance
Next
From: Maximilian Tyrtania
Date:
Subject: Re: insufficient file descriptors on Mac OS X