Re: BUG #1733: Function visibility in transactions error

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Grabowski <grabba(at)env(dot)pl>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1733: Function visibility in transactions error
Date: 2005-06-28 08:32:46
Message-ID: 42C10B2E.9020209@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Paolo Petranzan 2005-06-28 11:34:42 BUG #1734: Can't install in D:\
Previous Message Robert Grabowski 2005-06-28 06:49:40 Re: BUG #1733: Function visibility in transactions error