The following bug has been logged on the website: Bug reference: 7865 Logged by: Matti Aarnio Email address: matti.aar...@methics.fi PostgreSQL version: 9.2.2 Operating system: Fedora Linux 17/18 Description:
A table: CREATE TABLE example ( a TIMESTAMP NOT NULL, b VARCHAR(256) NOT NULL, c VARCHAR(256) NOT NULL, PRIMARY KEY(a,b,c) ); Inserting a duplicate record on this is returning an SQL Error, but the status code is 0 instead of expected 23505. This used to work fine in 8.x series, but is now causing trouble in 9.1.7, and 9.2.3. My application filters by the status code to detect if the issue is really duplicate value, or some database service error. In a few cases we want to see "it is duplicate!" in order to allow an operation elsewhere. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
