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

From Sergey Burladyan
Subject psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'
Date
Msg-id 87r5ge356k.fsf@home.progtech.ru
Whole thread Raw
Responses Re: psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'
List pgsql-bugs
seb=> select version();
                                               version
------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4.4 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.4-7) 4.4.4, 64-bit
(1 row)

Time: 0,074 ms
seb=> abort;
ROLLBACK
Time: 0,086 ms
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.
I don't know, may be this is expected behavior.

--
Sergey Burladyan

pgsql-bugs by date:

Previous
From: Itagaki Takahiro
Date:
Subject: Re: BUG #5674: initdb failed if path contains symlink
Next
From: "Henk Dekker"
Date:
Subject: Re: BUG #5679: pgAdminIII 1.12.0 hangs