> > What about that doesn't make sense? Having SET begin a transaction > > seems like a gross violation of POLS and likely to contradict the spec > > and cause problems with many applications. -sc > > I think we left the standard when we made SET rollbackable. Maybe that > has to be reopened because if we did that, it would make perfect sense > because all SETs would be outside transactions.
Of course, the reason they're rollbackable is: begin; create schema newschema; set search_path = newschema; rollback; create table junk; -- DOH! -- Rod Taylor ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
