Re: Small Bug in GetConflictingVirtualXIDs
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org, Simon Riggs <simon@2ndquadrant.com>
Date: 2009-12-21T15:38:07Z
Lists: 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