Re: "duplicate key value": version 8.4 vs 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mountain oaf <mountainoaf(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: "duplicate key value": version 8.4 vs 8.1
Date: 2010-10-21 02:36:11
Message-ID: 9996.1287628571@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

mountain oaf <mountainoaf(at)gmail(dot)com> writes:
>> AFAICS the ecpg code around that hasn't changed since 8.1, so I think
>> your assumption is in error. You might try looking into the server
>> log to see what it thinks is happening.

> I've just done a test on the 8.1.2 database where I purposely added a
> duplicate record and the sqlca.sqlcode returned a -400 error.

So, the server is returning some error code, but it's not 23505.
Again, I'd suggest looking at the server log to see what it thinks
is happening. My bet is that you're trying to use some feature
that doesn't exist in 8.1 ...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message mountain oaf 2010-10-21 02:58:57 Re: "duplicate key value": version 8.4 vs 8.1
Previous Message Bruce Momjian 2010-10-21 02:30:22 Re: Asynchronous I/O in Postgres