Re: BUG #1733: Function visibility in transactions error - Mailing list pgsql-bugs

From Robert Grabowski
Subject Re: BUG #1733: Function visibility in transactions error
Date
Msg-id 42C0F304.6070008@env.pl
Whole thread Raw
In response to Re: BUG #1733: Function visibility in transactions error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> "Robert Grabowski" <grabba@env.pl> 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

pgsql-bugs by date:

Previous
From: "Paolo Petranzan"
Date:
Subject: BUG #1734: Can't install in D:\
Next
From: "Magnus Hagander"
Date:
Subject: Re: BUG #1734: Can't install in D:\