Thread: How can I get a restrict_violation?

Hi.

While looking through the error codes in Appendix 1 in the doc, I
found restrict_violation.

What is that and how do I get it?

A B <gentosaker@gmail.com> writes:
> While looking through the error codes in Appendix 1 in the doc, I
> found restrict_violation.

> What is that and how do I get it?

RESTRICT_VIOLATION is one of the SQLSTATE codes specified in the SQL
standard, but so far as a quick grep finds, it's not actually thrown
anywhere in Postgres at the moment.  So the answer is "you can't".

            regards, tom lane