Re: Two different methods of sneaking non-immutable data into an index - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Two different methods of sneaking non-immutable data into an index
Date
Msg-id AANLkTi=nD4tWz_3KVtqZvUOt0eO5bKAu8dYVjiQqMGmg@mail.gmail.com
Whole thread Raw
In response to Two different methods of sneaking non-immutable data into an index  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Two different methods of sneaking non-immutable data into an index
List pgsql-hackers
On Wed, Aug 4, 2010 at 6:43 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> *) also, isn't it possible to change text cast influencing GUCs 'n'
> times per statement considering any query can call a function and any
> function can say, change datestyle?  Shouldn't the related functions
> be marked 'volatile', not stable?

This is just evil.  It seems to me that we might want to instead
prevent functions from changing things for their callers, or
postponing any such changes until the end of the statement, or, uh,
something.  We can't afford to put ourselves in a situation of having
to make everything volatile; at least, not if "performance" is
anywhere in our top 50 goals.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: more numeric stuff
Next
From: Robert Haas
Date:
Subject: Re: review: psql: edit function, show function commands patch