daniel wrote:
put
\set AUTOCOMMIT 'off'
in your configuration file and you're done.
daniel
> John Sidney-Woollett wrote:
>
>> OK that's exactly what I want - thanks! I wasn't aware of a global
>> psqlrc file.
>>
>> BTW, I still think the default behaviour is incorrect...
>>
>> But at least I can work around it now and have the change be global. :)
>>
>> Thanks again
>>
>> John Sidney-Woollett
>>
>> Peter Eisentraut wrote:
>>
>>> John Sidney-Woollett wrote:
>>>
>>>> I'd like to see a global setting that I could change, not one on a
>>>> user by user basis...
>>>
>>>
>>>
>>>
>>> Then I suggest that in addition to the per-user configuration file
>>> ~/.psqlrc you implement a global configuration file
>>> /etc/postgresql/psqlrc. That would be the place you could put such
>>> a setting.
>>>
>>>
>>>> I'd also like a message in the Welcome banner telling me what the
>>>> current AUTOCOMMIT setting is...
>>>
>>>
>>>
>>>
>>> Put
>>>
>>> \echo 'AUTOCOMMIT is' :AUTOCOMMIT
>>>
>>> in your configuration file and you're done.
>>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>