>> 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