What kinds of simple expressions need a snapshot?

From: T <kurt023(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: What kinds of simple expressions need a snapshot?
Date: 2014-07-03 13:00:22
Message-ID: BAY173-W10DAFD6C93661DA348A013E6010@phx.gbl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Arup Rakshit 2014-07-03 13:08:08 Re: converting a N rows table to a 1 row table ?
Previous Message Chris Curvey 2014-07-03 12:53:53 Re: converting a N rows table to a 1 row table ?