Re: psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off' - Mailing list pgsql-bugs

From Itagaki Takahiro
Subject Re: psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'
Date
Msg-id AANLkTik+2NrqwzMS540i2_SVCGx0wyCaw7_m5HEZZAGO@mail.gmail.com
Whole thread Raw
In response to psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'  (Sergey Burladyan <eshkinkot@gmail.com>)
List pgsql-bugs
On Tue, Sep 28, 2010 at 12:41 PM, Sergey Burladyan <eshkinkot@gmail.com> wr=
ote:
> seb=3D> DISCARD ALL ;
> ERROR: =C2=A0DISCARD ALL cannot run inside a transaction block
>
> DISCARD is not mentioned anywhere in the src/bin/psql/common.c
> in command_no_begin(const char *query) function.

Thank you for the bug report!
Fixed and backpatched to 8.3.

--=20
Itagaki Takahiro

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #5679: pgAdminIII 1.12.0 hangs
Next
From: Tom Lane
Date:
Subject: Re: BUG #5680: Failure to start: too many private dirs demanded