Re: Check constraints on non-immutable keys - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Check constraints on non-immutable keys
Date
Msg-id 10358.1277910128@sss.pgh.pa.us
Whole thread Raw
In response to Re: Check constraints on non-immutable keys  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Check constraints on non-immutable keys  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> On Wed, Jun 30, 2010 at 16:38, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The example seems to me to be in the category of "so don't do that"
>> rather than something that we need to save users from. �Yes, it's

> In that case, should we at least throw a warning?

I don't see a reason to do that.  If we could distinguish actually
problematic cases from safe cases, it would be helpful, but we can't.

Moreover, throwing a warning would encourage people to do actively
*unsafe* things to suppress the warning --- like marking functions
as immutable when they really aren't.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Keepalives win32
Next
From: Tom Lane
Date:
Subject: Re: Keepalives win32