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,
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
"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
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