Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > On Mon, 2004-03-01 at 20:43, Bruno Wolff III wrote: >> Tom Lane <[EMAIL PROTECTED]> wrote: >>> Michael Glaesemann <[EMAIL PROTECTED]> writes: In both cases, the CHECK constraint uses a function that is stable or volatile. It was suggested that fun

Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Rod Taylor
On Mon, 2004-03-01 at 20:43, Bruno Wolff III wrote: > On Mon, Mar 01, 2004 at 20:28:02 -0500, > Tom Lane <[EMAIL PROTECTED]> wrote: > > Michael Glaesemann <[EMAIL PROTECTED]> writes: > > > In both cases, the CHECK constraint uses a function that is stable or > > > volatile. It was suggested that

Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Bruno Wolff III
On Mon, Mar 01, 2004 at 20:28:02 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Michael Glaesemann <[EMAIL PROTECTED]> writes: > > In both cases, the CHECK constraint uses a function that is stable or > > volatile. It was suggested that functions used in CHECK constraints be > > restricted to imm

Re: [HACKERS] CHECK constraints inconsistencies

2004-03-01 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > In both cases, the CHECK constraint uses a function that is stable or > volatile. It was suggested that functions used in CHECK constraints be > restricted to immutable, This seems reasonable to me. I'm a bit surprised we do not have such a check