"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