| From: | Ron St-Pierre <ron(dot)pgsql(at)shaw(dot)ca> |
|---|---|
| To: | general <pgsql-general(at)postgresql(dot)org> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Subject: | Re: PL/pgSQL Problem |
| Date: | 2006-08-09 20:33:37 |
| Message-ID: | 44DA46A1.5060805@shaw.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-08-09 20:34:47 | Re: WIN32 Build? |
| Previous Message | Tom Lane | 2006-08-09 20:28:18 | Re: WIN32 Build? |