Postgres Pro
Downloads
Home   >   mailing lists

Thread: set AUTOCOMMIT OFF in psqlrc not having affect

set AUTOCOMMIT OFF in psqlrc not having affect

From
Christian Fowler
Date:
I have \set AUTOCOMMIT OFF in my .psqlrc and it seems psql seems to not
have any effect. Am I missing something? I've been googling and googling
and seem a bit lost at this point.


[domain@host host]$ cat ~/.psqlrc
\set AUTOCOMMIT OFF
\echo 'AUTOCOMMIT is' :AUTOCOMMIT
\set PROMPT1 'host.%/%R%# '
\timing

*timing statments where trimmed below*

[domain@host host]$ psql
Welcome to psql 7.4.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help on internal slash commands
        \g or terminate with semicolon to execute query
        \q to quit

AUTOCOMMIT is OFF
Timing is on.
host.domain=# commit;
WARNING:  there is no transaction in progress
COMMIT
host.domain=# update foo set foo_type_id = 3 where foo_id=200000234;
UPDATE 1
host.domain=# commit;
WARNING:  there is no transaction in progress
COMMIT
host.domain=# update foo set foo_type_id = 3 where foo_id=200000234;
UPDATE 1
host.domain=# rollback;
WARNING:  there is no transaction in progress
ROLLBACK
host.domain=# begin;
BEGIN
host.domain=# update foo set foo_type_id = 3 where foo_id=200000234;
UPDATE 1
host.domain=# rollback;
ROLLBACK
host.domain=# begin;
BEGIN
host.domain=# update foo set foo_type_id = 3 where foo_id=200000234;
UPDATE 1
host.domain=# rollback;
ROLLBACK
host.domain=# \q

[ \ /
[ >X<   Christian Fowler      | spider@viovio.com
[ / \   http://www.viovio.com | http://www.tikipro.org

Re: set AUTOCOMMIT OFF in psqlrc not having affect

From
Tom Lane
Date:
Christian Fowler <spider@viovio.com> writes:
> I have \set AUTOCOMMIT OFF in my .psqlrc and it seems psql seems to not
> have any effect.

I think the value is case-sensitive.  Try
    \set AUTOCOMMIT off

            regards, tom lane

Re: set AUTOCOMMIT OFF in psqlrc not having affect

From
Bruce Momjian
Date:
FYI, it is not case-sensitive in current CVS.

---------------------------------------------------------------------------

Tom Lane wrote:
> Christian Fowler <spider@viovio.com> writes:
> > I have \set AUTOCOMMIT OFF in my .psqlrc and it seems psql seems to not
> > have any effect.
>
> I think the value is case-sensitive.  Try
>     \set AUTOCOMMIT off
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: set AUTOCOMMIT OFF in psqlrc not having affect

From
Christian Fowler
Date:
Thanks Tom, it appears that was the issue. Bruce, it would appear it
was at some point? Glad to hear it's now insensitive.



On Sun, 17 Oct 2004, Bruce Momjian wrote:

>
> FYI, it is not case-sensitive in current CVS.
>
> Tom Lane wrote:
>> Christian Fowler <spider@viovio.com> writes:
>>> I have \set AUTOCOMMIT OFF in my .psqlrc and it seems psql seems to not
>>> have any effect.
>>
>> I think the value is case-sensitive.  Try
>>     \set AUTOCOMMIT off
>

[ \ /
[ >X<   Christian Fowler      | spider@viovio.com
[ / \   http://www.viovio.com | http://www.tikipro.org

Re: set AUTOCOMMIT OFF in psqlrc not having affect

From
Bruce Momjian
Date:
Christian Fowler wrote:
>
> Thanks Tom, it appears that was the issue. Bruce, it would appear it
> was at some point? Glad to hear it's now insensitive.

Yes, it was always true until a few days ago. Sorry that wasn't clear.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073