pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
set AUTOCOMMIT OFF in psqlrc not having affect
5+ messages / 3 participants
[nested] [flat]

* set AUTOCOMMIT OFF in psqlrc not having affect
@ 2004-10-17 18:47 Christian Fowler <spider@viovio.com>
  2004-10-17 19:38 ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Christian Fowler @ 2004-10-17 18:47 UTC (permalink / raw)
  To: pgsql-admin


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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: set AUTOCOMMIT OFF in psqlrc not having affect
  2004-10-17 18:47 set AUTOCOMMIT OFF in psqlrc not having affect Christian Fowler <spider@viovio.com>
@ 2004-10-17 19:38 ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-17 21:07   ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Lane @ 2004-10-17 19:38 UTC (permalink / raw)
  To: Christian Fowler <spider@viovio.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: set AUTOCOMMIT OFF in psqlrc not having affect
  2004-10-17 18:47 set AUTOCOMMIT OFF in psqlrc not having affect Christian Fowler <spider@viovio.com>
  2004-10-17 19:38 ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-17 21:07   ` Bruce Momjian <pgman@candle.pha.pa.us>
  2004-10-17 21:25     ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Christian Fowler <spider@viovio.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Bruce Momjian @ 2004-10-17 21:07 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Christian Fowler <spider@viovio.com>; pgsql-admin


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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: set AUTOCOMMIT OFF in psqlrc not having affect
  2004-10-17 18:47 set AUTOCOMMIT OFF in psqlrc not having affect Christian Fowler <spider@viovio.com>
  2004-10-17 19:38 ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-17 21:07   ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Bruce Momjian <pgman@candle.pha.pa.us>
@ 2004-10-17 21:25     ` Christian Fowler <spider@viovio.com>
  2004-10-18 02:23       ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Christian Fowler @ 2004-10-17 21:25 UTC (permalink / raw)
  To: pgsql-admin


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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: set AUTOCOMMIT OFF in psqlrc not having affect
  2004-10-17 18:47 set AUTOCOMMIT OFF in psqlrc not having affect Christian Fowler <spider@viovio.com>
  2004-10-17 19:38 ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-17 21:07   ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Bruce Momjian <pgman@candle.pha.pa.us>
  2004-10-17 21:25     ` Re: set AUTOCOMMIT OFF in psqlrc not having affect Christian Fowler <spider@viovio.com>
@ 2004-10-18 02:23       ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 5+ messages in thread

From: Bruce Momjian @ 2004-10-18 02:23 UTC (permalink / raw)
  To: Christian Fowler <spider@viovio.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-10-18 02:23 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-17 18:47 set AUTOCOMMIT OFF in psqlrc not having affect Christian Fowler <spider@viovio.com>
2004-10-17 19:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-17 21:07   ` Bruce Momjian <pgman@candle.pha.pa.us>
2004-10-17 21:25     ` Christian Fowler <spider@viovio.com>
2004-10-18 02:23       ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox