Re: BUG #2265: CREATE TABLE when AUTOCOMMIT is OFF

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Gerhard Lutz <gerhard(dot)lutz(at)mbtech-group(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2265: CREATE TABLE when AUTOCOMMIT is OFF
Date: 2006-02-16 18:13:52
Message-ID: 20060216181352.GA32176@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Feb 16, 2006 at 01:21:18PM +0000, Gerhard Lutz wrote:
> "Error while executing the query;
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block (7)"

Some previous command failed so no more commands in this transaction
will be allowed. If you don't know what command failed then you
could configure query logging.

> In PostgreSQL 8.0.4 I was able to create a table in AUTOCOMMIT mode OFF
> without any error. Is this a bug in 8.1.3?

The error is apparently happening before the CREATE TABLE command.
Let's see what earlier command failed and why.

--
Michael Fuhr

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2006-02-17 10:56:16 Re: BUG #2269: cannot connect to postgres database on Linux
Previous Message Ken 2006-02-16 17:46:42 BUG #2269: cannot connect to postgres database on Linux