On Mon, Jan 08, 2007 at 03:42:47PM +0000, [EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] wrote: > > Can someone tell me why attach cannot be called within transaction? > > I do not recall. > > Clearly a DETACH will not work inside a transaction if the > table being detached has been accessed or modified within that > transaction. But ATTACH could work, I would think. > > Perhaps we disallowed ATTACH so that people would not expect > an automatic DETACH if the transaction rolls back?
It certainly doesn't rollback. I just tried it. No crashes though, and no other obvious bugs. But that ATTACH does not rollback seems like a decent reason not to allow it in transactions. Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
