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
