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

Re: Query tool result discarding

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>,<pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Query tool result discarding
Date: 2006-02-06 09:52:26
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40103DEA7@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
Thanks, patch applied.

/D 

> -----Original Message-----
> From: pgadmin-hackers-owner(at)postgresql(dot)org 
> [mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of 
> Magnus Hagander
> Sent: 02 February 2006 10:12
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Query tool result discarding
> 
> Hi!
> 
> 
> A fairly typical use-case for the query tool in my org is:
> 
> BEGIN TRANSACTION;
> UPDATE something SET somecol=newval WHERE something=other;
> SELECT * FROM something;   -- this is to manually verify results
> ROLLBACK;
> 
> Then when everything works, you replace ROLLBACK with COMMIT. 
> This works
> perfectly in the query tool in sqlserver, but pgAdmin discards the
> result from SELECT and leaves the result pane empty. Because it's
> overwritten by the empty result from ROLLBACK.
> 
> Attached patch fixes this very limited test case. I'm well enough
> unfamiliar with that code that I think it's probably not the correct
> solution "in the big scheme" (and it also seems too easy), 
> but it might
> help point one of you guys who know that code better in the right
> direction. Or on the off chance that it's right, hey, there was some
> luck left over :-)
> 
> //Magnus
> 

pgadmin-hackers by date

Next:From: svnDate: 2006-02-06 10:12:52
Subject: SVN Commit by dpage: r4987 - in trunk/pgadmin3: . src/base src/frm src/include/base
Previous:From: svnDate: 2006-02-06 09:52:14
Subject: SVN Commit by dpage: r4986 - in trunk/pgadmin3: . src/base

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group