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

Reply via email to