Hi,
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.
Regards,
C. Duprez
