"Tomeh, Husam" <HTomeh@xxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
