pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedset 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>
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 19:38 Tom Lane <tgl@sss.pgh.pa.us>
parent: Christian Fowler <spider@viovio.com>
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 21:07 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
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 21:25 Christian Fowler <spider@viovio.com>
parent: 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-18 02:23 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Christian Fowler <spider@viovio.com>
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