Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group