Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-bugs by date:

Previous
From: "Robert Grabowski"
Date:
Subject: BUG #1733: Function visibility in transactions error
Next
From: Neil Conway
Date:
Subject: Re: BUG #1733: Function visibility in transactions error