Michael Fuhr wrote:
On Wed, Aug 09, 2006 at 10:33:02AM -0700, Ron St-Pierre wrote:
ERROR: duplicate key violates unique constraint "systemcounts_pkey"
CONTEXT: SQL statement "INSERT INTO dm.systemCounts (updateDate) VALUES (
$1 ::date)"
PL/pgSQL function "updatesystemcounts" line 8 at SQL statement
Is the table's primary key a serial column? If so then the sequence
might be out of sync with the values in the table, in which case
you'll need to adjust the sequence's value with ALTER SEQUENCE or
setval().
Aha, that was exactly what the problem was.
Thanks!
Ron
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings