AW: Can the backend return more than one error message per PQexec?

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Can the backend return more than one error message per PQexec?
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368312@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
>     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 valueexec sql update blabla set ... ;

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: Re: [PATCHES] Fw: Isn't pg_statistic a security hol e - Solution Proposal
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Standards