>> Should psql run every statement in a nested transaction and only rollback >> that TX?
> psql is designed to follow the same logical statement progression as any > other connection to the database. Your suggestion could muck up sql > scripts piped through it to the database. The other objection is that this would create very substantial overhead. It might be reasonable to offer that behavior as an option, but I think I'd only want it on for interactive input. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly