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

[pgAdmin III] #47: Savepoints in PgAdmin

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #47: Savepoints in PgAdmin
Date: 2009-08-21 07:49:56
Message-ID: 053.5de002a1eee9b14c1cd66297637699d4@code.pgadmin.org (view raw or flat)
Thread:
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 :

 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

Responses

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-2014 The PostgreSQL Global Development Group