Domains, check_violation and undefined column field in error

Поиск
Список
Период
Сортировка
От Andri Möll
Тема Domains, check_violation and undefined column field in error
Дата
Msg-id 55F2B735.8000502@dot.ee
обсуждение исходный текст
Ответы Re: Domains, check_violation and undefined column field in error
Список pgsql-general
Hey,

I'm giving DOMAINs a shot and created a simple one with a CHECK on
PostgreSQL 9.4.4. Sadly, when the check fails, the thrown error (23514,
check_violation) doesn't seem to contain the column information in the
"c" field. Should it? Is it just not implemented?

http://www.postgresql.org/docs/9.4/static/errcodes-appendix.html says
«As of PostgreSQL 9.3, complete coverage for this feature exists only
for errors in SQLSTATE class 23 (integrity constraint violation), but
this is likely to be expanded in future.» I believe CHECK violation is
in the 23th class.

Thanks in advance!

Andri


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

Предыдущее
От: Sridhar N Bamandlapally
Дата:
Сообщение: Re: avoid lock conflict between SELECT and TRUNCATE
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Domains, check_violation and undefined column field in error