Postgres Pro
Downloads
Home   >   mailing lists

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

From mountain oaf
Subject Re: "duplicate key value": version 8.4 vs 8.1
Date
Msg-id AANLkTimHQ54aYHL+KyxNEFmZhBQab6UCu9MSBHjRhEv2@mail.gmail.com
Whole thread Raw
In response to Re: "duplicate key value": version 8.4 vs 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "duplicate key value": version 8.4 vs 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
> 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.

Mark

pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Incremental Backup
Next
From: Bruce Momjian
Date:
Subject: Re: Asynchronous I/O in Postgres