
> 	ERROR: blah blah
> 	CODE: 12345
> 	LOCATION: some/file.c line NNN

It might be handy to have the LOCATION in the postmaster log,
or make it something that needs to be explicitly switched on.
I do not think it is of general interest to users (most errors 
will result from normal operation, and not bugs that need to be tracked).

Since access to SQLSTATE will become a hot path once savepoints 
are available I think that having SQLSTATE up front would be
more convenient.

exec sql insert into blabla values ....;
if (strncmp(sqlca.sqlstate, "23", 2) == 0)	// duplicate key value
	exec sql update blabla set ... ;

Andreas

Thu, 7 Jun 2001 11:40:22 +0200 
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
AW: Can the backend return more than one error message per PQexec? 