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: (view raw or whole thread)
Lists: pgadmin-hackers
Thanks, patch applied.


> -----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:
> UPDATE something SET somecol=newval WHERE something=other;
> SELECT * FROM something;   -- this is to manually verify results
> 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-2015 The PostgreSQL Global Development Group