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

Re: create table in transaction fails

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: psql(at)dgrmm(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: create table in transaction fails
Date: 2005-10-30 18:56:44
Message-ID: 20051030185644.GB19496@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
On Sat, Oct 29, 2005 at 05:56:41PM -0500, psql(at)dgrmm(dot)net wrote:
> I have a php script to upgrade a database, and it works just fine when not in a
> transaction, but it fails when I turn on a transaction.

When you start a transaction and you get an error, all subsequent
commands will be ignored until you commit or rollback.

> The error is:
> 
> [db_error: message="DB Error: unknown error" code=-1 mode=return level=notice
> prefix="" info="CREATE TABLE maia_themes ( id SERIAL PRIMARY KEY, name
> VARCHAR(30) NOT NULL, path VARCHAR(30) NOT NULL) [nativecode=ERROR: current
> transaction is aborted, commands ignored until end of transaction block]"]

No, this is the message telling you it's ignoring the command. The
actual error is ealier in the same transaction... Fix that and this
will solve itself...

Hope this helps,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2005-10-30 19:05:09
Subject: Re: Please HELP - URGENT - transaction wraparound error
Previous:From: John Sidney-WoollettDate: 2005-10-30 18:41:45
Subject: Re: Please HELP - URGENT - transaction wraparound error

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