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

Re: pgAdmin III bug with transaction failure

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: RStefko(at)aol(dot)com,"'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin III bug with transaction failure
Date: 2004-09-17 15:36:33
Message-ID: 414B0481.30900@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
RStefko(at)aol(dot)com wrote:
> The default behavior in pgsql is to allow the use of transactions to 
> isolate SQL statements.  PgAdmin seems to batch the entire script into a 
> single transaction, making the user's transaction irrelevant.

Use the mailing list!

To pgAdmin, all you execute is a single statement. Execute them 
separately or use savepoints.

Regards,
Andreas

pgadmin-support by date

Next:From: Ted TaylorDate: 2004-09-18 00:56:36
Subject: Create Database - Owner - 7.4.5 backend
Previous:From: Ted TaylorDate: 2004-09-17 15:32:47
Subject: Re: Error adding new column to existing table.

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