Re: [GENERAL] PL/pgSQL Problem

2006-08-09 Thread Ron St-Pierre
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

Re: [GENERAL] PL/pgSQL Problem

2006-08-09 Thread Merlin Moncure
On 8/9/06, Ron St-Pierre <[EMAIL PROTECTED]> wrote: Hi, I'm having a problem with one of my functions, where I delete all rows containing a particular date and then re-insert a row with that same date. When I try this I get a constraint error. This just started recently, after upgrading our datab

Re: [GENERAL] PL/pgSQL Problem

2006-08-09 Thread Michael Fuhr
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