Re: psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: Sergey Burladyan <eshkinkot(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'
Date: 2010-09-28 05:33:34
Message-ID: AANLkTik+2NrqwzMS540i2_SVCGx0wyCaw7_m5HEZZAGO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Sep 28, 2010 at 12:41 PM, Sergey Burladyan <eshkinkot(at)gmail(dot)com> wrote:
> seb=> DISCARD ALL ;
> ERROR:  DISCARD 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.

--
Itagaki Takahiro

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2010-09-28 06:11:53 Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous Message Craig Ringer 2010-09-28 05:32:20 Re: BUG #5679: pgAdminIII 1.12.0 hangs