Tom Lane wrote:
"Robert Grabowski" <[EMAIL PROTECTED]> writes:

I have problem with function visibility in transaction when I do create and
drop function.


System catalog lookups generally follow SnapshotNow rules, not MVCC.
So the new function definition is visible as soon as it's committed,
whether you are in a serializable transaction or not.

                        regards, tom lane



Hi!

OK. I can understand that. But why at first call after update function have I results of the old function, and at second call in the same transaction I have results of the new function. It is strange for me.

pozdrawiam
   Robert Grabowski





---------------------------(end of broadcast)---------------------------
TIP 3: 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

Reply via email to