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: (view raw, whole thread or download thread mbox)
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>
> 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-2017 The PostgreSQL Global Development Group