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

[pgAdmin III] #47: Savepoints in PgAdmin

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #47: Savepoints in PgAdmin
Date: 2009-08-21 07:49:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
#47: Savepoints in PgAdmin
 Reporter:  Cédric DUPREZ  |       Owner:  dpage 
     Type:  bug            |      Status:  new   
 Priority:  minor          |   Milestone:  1.10.1
Component:  pgadmin        |     Version:  1.8   
 Keywords:  querytool      |    Platform:  all   
 I am using PgAdmin 1.10.0 with Postgresql 8.3.7 on Windows XP Pro (SP3).

 The problem I am facing deals with savepoint and rollback management in
 PgAdmin. I initiate a transaction, then I run different queries, create a
 savepoint :

 CREATE temp TABLE toto (id int);
 SAVEPOINT my_save;

 Then, I execute a wrong query :


 I get an error message :

 ERROR: relation "toto" does not exist
 ********** Erreur **********
 ERROR: relation "toto" does not exist
 État SQL :42P01

 But I can't rollback to my savepoint, because a complete rollback has
 already been executed by PgAdmin :

 ROLLBACK TO my_save;

 ERROR: ROLLBACK TO SAVEPOINT can only be used in transaction blocks
 ********** Erreur **********
 ERROR: ROLLBACK TO SAVEPOINT can only be used in transaction blocks
 État SQL :25P01

 This problem seems to come from the fact that PgAdmin executes code in a
 single transaction statement... How is it possible to create different
 transaction statements within PgAdmin, in order to use savepoints ?

 Thanks in advance for your help.

Ticket URL: <>
pgAdmin III <>
pgAdmin III


pgadmin-hackers by date

Next:From: pgAdmin TracDate: 2009-08-21 07:50:47
Subject: Re: [pgAdmin III] #47: Savepoints in PgAdmin
Previous:From: TimonDate: 2009-08-21 06:13:54
Subject: automake-1.11

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