mountain oaf <mountainoaf(at)gmail(dot)com> writes:
> When I run it against an 8.4.4 version of Postgres, data inserted into
> a table which violate an unique index are reported back to the program
> via sqlca.sqlcode as -403 ('duplicate key value violates unique
> constraint "my_index"').
> However, when I run the same program against an 8.1.2 database, the
> error isn't trapped. I'm explicitly looking for a -403 code via
> sqlca.sqlcode so am assuming that the error code is different in this
> version of the database.
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.
regards, tom lane