Horton
Menu

Re: Small Bug in GetConflictingVirtualXIDs

Alvaro Herrera <alvherre@commandprompt.com>

View thread
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@postgresql.org, Simon Riggs <simon@2ndquadrant.com>
Date: 2009-12-21T15:25:34Z
Lists: pgsql-hackers 
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?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support