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

From: Sergey Burladyan <eshkinkot(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: psql: cannot run DISCARD ALL with AUTOCOMMIT = 'off'
Date: 2010-09-28 03:41:55
Message-ID: 87r5ge356k.fsf@home.progtech.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2010-09-28 04:51:11 Re: [BUGS] Mapping Hibernate boolean to smallint(Postgresql)
Previous Message Itagaki Takahiro 2010-09-28 01:28:53 Re: BUG #5674: initdb failed if path contains symlink