Re: [BUGS] BUG #1733: Function visibility in transactions error

2005-06-28 Thread Robert Grabowski
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,

Re: [BUGS] BUG #1733: Function visibility in transactions error

2005-06-28 Thread Neil Conway
Tom Lane wrote: 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. IMHO this is a bug, or at least not optimal behavior. But per the discussion on -hacke

Re: [BUGS] BUG #1733: Function visibility in transactions error

2005-06-27 Thread Tom Lane
"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

[BUGS] BUG #1733: Function visibility in transactions error

2005-06-27 Thread Robert Grabowski
The following bug has been logged online: Bug reference: 1733 Logged by: Robert Grabowski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux 2.6.12-gentoo Description:Function visibility in transactions error Details: I have problem w