Domains, check_violation and undefined column field in error

From: Andri Möll <andri(at)dot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Domains, check_violation and undefined column field in error
Date: 2015-09-11 11:12:53
Message-ID: 55F2B735.8000502@dot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-09-11 12:17:42 Re: Domains, check_violation and undefined column field in error
Previous Message Sridhar N Bamandlapally 2015-09-11 09:50:07 Re: avoid lock conflict between SELECT and TRUNCATE