#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