Postgres Pro
Downloads
Home   >   mailing lists

Re: Domains, check_violation and undefined column field in error - Mailing list pgsql-general

From David G. Johnston
Subject Re: Domains, check_violation and undefined column field in error
Date
Msg-id CAKFQuwY-qVERCg80qc9oC1DyO2qdYHr2Q0J_9cbthP2aWWteGA@mail.gmail.com
Whole thread Raw
In response to Domains, check_violation and undefined column field in error  (Andri Möll <andri@dot.ee>)
List pgsql-general
Tree view
On Friday, September 11, 2015, Andri Möll <andri@dot.ee> wrote:
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


An example might help but type input functions do not require nor receive column information since it is possible to be processing a simple literal that is not associated with any ore-defined table or view column.

David J. 

pgsql-general by date:

Previous
From: Andri Möll
Date:
Subject: Domains, check_violation and undefined column field in error
Next
From: Melvin Davidson
Date:
Subject: Re: clone_schema function