Re: [HACKERS] psql default options

[Jim Nasby]

On Apr 27, 2007, at 12:44 AM, Tom Lane wrote:

Gregory Stark <[EMAIL PROTECTED]> 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[EMAIL PROTECTED]
EnterpriseDB  http://enterprisedb.com  512.569.9461 (cell)



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] psql default options

[Tom Lane]

Gregory Stark <[EMAIL PROTECTED]> 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.

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings