Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group