On Sun, 2007-01-07 at 11:29 -0500, Tom Lane wrote: > I wrote: > > ... The active-portal kluge that you've just > > mentioned is nothing but a kluge, proving that you thought of some cases > > where it would fail. But I doubt you thought of everything.
New patch submitted to -patches on different thread. ...continuing this discussion about setting HEAP_XMIN_COMMITTED... > BTW, a sufficient counterexample for that kluge is that neither SPI or > SQL-function execution use a separate portal for invoked commands. Thus > testing whether there's only one active portal isn't sufficient to prove > that you're not inside a function executing in serializable mode, and > thus it could have a transaction snapshot predating the COPY. What would the best/acceptable way be to test for this condition? Using if (IsXactIsoLevelSerializable) would not be a very tight condition, but at least it would avoid putting additional status flags into every transaction, just to test for this case in COPY statements. ISTM unlikely that people would try to use COPY in Serializable mode; what do people think? -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly