Postgres Pro
Downloads
Home   >   mailing lists

Re: Check-out mutable functions in check constraints - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Check-out mutable functions in check constraints
Date
Msg-id CAFj8pRCY=gUKik9-DfABgcsDzJf2iYOsTpO8fkWs+X1NFYtgUQ@mail.gmail.com
Whole thread Raw
In response to Check-out mutable functions in check constraints  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: Check-out mutable functions in check constraints  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view
Hi

pá 12. 7. 2019 v 8:45 odesílatel Kyotaro Horiguchi <horikyota.ntt@gmail.com> napsal:
Hello.

As mentioned in the following message:

https://www.postgresql.org/message-id/20190712.150527.145133646.horikyota.ntt%40gmail.com

Mutable function are allowed in check constraint expressions but
it is not right. The attached is a proposed fix for it including
regression test.

Other "constraints vs xxxx" checks do not seem to be exercised
but it would be another issue.

I think so this feature (although is correct) can breaks almost all applications - it is 20 year late.

Regards

Pavel


regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Check-out mutable functions in check constraints
Next
From: Tomas Vondra
Date:
Subject: Re: Memory-Bounded Hash Aggregation