What kinds of simple expressions need a snapshot? - Mailing list pgsql-general

From T
Subject What kinds of simple expressions need a snapshot?
Date
Msg-id BAY173-W10DAFD6C93661DA348A013E6010@phx.gbl
Whole thread Raw
List pgsql-general
Hi,
I'm reading code in plpgsql, and I notice that exec_eval_simple_expr() will get a snapshot for the expr if it is in a VOLATILE function.
Then I try to find out why a snapshot is needed for a expr which has passed exec_simple_check_plan(). The only reason I could figure out is that maybe VOLATILE functions are involved in this expr, are there some other situation I missed?

Thanks.

pgsql-general by date:

Previous
From: Chris Curvey
Date:
Subject: Re: converting a N rows table to a 1 row table ?
Next
From: Arup Rakshit
Date:
Subject: Re: converting a N rows table to a 1 row table ?