Re: Exclusion constraint issue - Mailing list pgsql-general

From Tom Lane
Subject Re: Exclusion constraint issue
Date
Msg-id 29345.1285510500@sss.pgh.pa.us
Whole thread Raw
In response to Re: Exclusion constraint issue  (David Fetter <david@fetter.org>)
Responses Re: Exclusion constraint issue  (David Fetter <david@fetter.org>)
List pgsql-general
David Fetter <david@fetter.org> writes:
> On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote:
>> period() might be immutable, but those casts from date to
>> timestamptz are not, because they depend on the TimeZone parameter.

> How hard would it be to point out the first expression found to be
> mutable?

I looked at that yesterday.  It would take significant restructuring
of the code involved :-( ... the place that throws the error doesn't
know exactly what subnode was found to be mutable, and IIRC it hasn't
got access to the original command string anyway.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 9.0RC1 error variable not found in subplantarget lists
Next
From: David Fetter
Date:
Subject: Re: Exclusion constraint issue