Re: Small Bug in GetConflictingVirtualXIDs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Small Bug in GetConflictingVirtualXIDs
Date
Msg-id 15331.1261409887@sss.pgh.pa.us
Whole thread Raw
In response to Re: Small Bug in GetConflictingVirtualXIDs  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Small Bug in GetConflictingVirtualXIDs
Re: Small Bug in GetConflictingVirtualXIDs
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Andres Freund wrote:
>> The logic behind this seems fine except in the case of dropping a database. 
>> There you very well might have a open connection without an open snapshot.

> Perhaps the simplest fix is to ensure that drop database gets a snapshot?

I confess to not having followed the thread closely, but why is DROP
DATABASE special in this regard?  Wouldn't we soon find ourselves
needing every utility command to take a snapshot?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rafael Martinez
Date:
Subject: Re: Table size does not include toast size
Next
From: Simon Riggs
Date:
Subject: Re: Small Bug in GetConflictingVirtualXIDs