Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs - Mailing list pgsql-bugs

From Jeff Davis
Subject Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs
Date
Msg-id CAMp0ubdy2Am4jA7ri875VJ6-9FR7TkkR7Lx3Kjvak+aFukG_-w@mail.gmail.com
Whole thread Raw
In response to Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs
List pgsql-bugs
On Wed, Nov 30, 2011 at 5:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The result of parse analysis for that query is a stored date constant
> (in a Const node) with a cast-to-text on top of it. =A0The system is aware
> that cast-date-to-text isn't immutable, so it doesn't try to fold the
> cast operation. =A0When you execute the query, it displays the date
> constant using the now-current datestyle.

Another thought: why does it execute the type input function (which is
dependent on a GUC), but not the cast?

Regards,
    Jeff Davis

pgsql-bugs by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names
Next
From: Tom Lane
Date:
Subject: Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs