Re: BUG #16158: Check constraints using SQL functions work incorrectly

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #16158: Check constraints using SQL functions work incorrectly
Дата
Msg-id CAKFQuwZHK-JV3_i-jyO_13VvOymqJhmT6XBnfgqepjSX+gNJ-A@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16158: Check constraints using SQL functions work incorrectly  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16158: Check constraints using SQL functions work incorrectly  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
On Tue, Dec 10, 2019 at 5:28 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16158
Logged by:          Piotr Jander
Email address:      pjander2@gmail.com
PostgreSQL version: 11.5
Operating system:   x86_64 GNU/Linux
Description:       

[...] 

My conjecture is that the bug is due to the use of SQL functions in the
check.
However, the
[docs](https://www.postgresql.org/docs/9.4/ddl-constraints.html)
on constraints do not mention any limitations on using such SQL functions
in
checks. If such limitations exist, they should be mentioned in the docs.

You should read the most current version of the documentation for a feature before reporting a bug.  In this case the warnings you desired have been added to more recently versions of the documentation.

https://www.postgresql.org/docs/12/ddl-constraints.html

Short answer, check constraints are designed to work only with data present on the table upon which they are defined.  Use triggers to work with other tables.

David J.

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16158: Check constraints using SQL functions work incorrectly
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16158: Check constraints using SQL functions work incorrectly