Re: Including Snapshot Info with Indexes - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: Including Snapshot Info with Indexes
Date
Msg-id 1191927892.16320.50.camel@PCD12478
Whole thread Raw
In response to Re: Including Snapshot Info with Indexes  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
> I think you're overly pessimistic here ;-) This classification can be done quite 
> efficiently as long as your language is "static enough". The trick is not to 
> execute the function, but to scan the code to find all other functions and SQL 
> statements a given function may possibly call. If your function calls no SQL 
> statements, and only other functions already marked IMMUTABLE, then it must be 
> IMMUTABLE itself.

OK, I have a "black-box" mindset right now due to the problem I'm
currently working on, so I didn't even think about checking the source
code of the function (which is the right thing to do if you have the
source code)... in which case you're right, I was overly pessimistic :-)

Cheers,
Csaba.




pgsql-hackers by date:

Previous
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: IndexTuple Structure
Next
From: Peter Eisentraut
Date:
Subject: Re: Uninformative messages from pg_ctl