On Sat, 2007-10-06 at 17:45 +0100, Dave Page wrote: > CIC can't be run in a transaction block, so how do we queue up the > drop & rename to run after it completes?
> Given the changes to VACUUM & CREATE DATABASE/TABLESPACE in 8.3 I > would imagine it won't run in a multi-statement query either now. Sounds like we need the ability to run multiple commands one after the other before we do that. Shame we lost the multi-stmt query, but it was correct to do that. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
