[pgAdmin III] #47: Savepoints in PgAdmin

#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 :

 BEGIN;
 CREATE temp TABLE toto (id int);
 INSERT INTO toto VALUES (1);
 SAVEPOINT my_save;

 Then, I execute a wrong query :

 SELECT * FROM tot;

 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: <http://code.pgadmin.org/trac/ticket/47>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III