On Apr 27, 2007, at 12:44 AM, Tom Lane wrote:
> Gregory Stark <stark@enterprisedb.com> writes:
>> I would like to suggest that we make psql default when in
>> interactive mode to
>> using AUTOCOMMIT=false and ON_ERROR_ROLLBACK=true.
>
> That is *way* too big a behavioral change to make depend on
> something as
> fragile as whether psql thinks it's interactive or not.
What about at least documenting it as a recommended practice? I agree
with Greg that it's a really good way to operate...
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)