Re: "duplicate key value": version 8.4 vs 8.1 - Mailing list pgsql-novice

mountain oaf <mountainoaf@gmail.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