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

From Neil Conway
Subject Re: BUG #1733: Function visibility in transactions error
Date
Msg-id 42C10B2E.9020209@samurai.com
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:
> 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 -hackers on this topic a few months ago, it seems pretty
difficult to fix.

-Neil

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1733: Function visibility in transactions error
Next
From: "Bobi Ivanov"
Date:
Subject: row number -1 is out of range 0..-1