Re: query returning no lines

[Dave Page]

> -----Original Message-----
> From: Guido Notari [mailto:[EMAIL PROTECTED]] 
> Sent: 16 October 2001 17:03
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] query returning no lines
> 
> 
> > I have a rather nasty problem with pgAdmin, verified today when I 
> > installed version .59 On reinstalling version .34, I 
> verified having 
> > the same problem -- didn't notice it before...
> >
> > The problem is, on executing an 'arbitrary SQL query', a rather
> complex
> > one, I continue to obtain a dialog box stating 'Query 
> Executed OK!', 
> > with no lines returned.
> 
> I'll answer to myself, as I found the problem:
> 
> The query being processed and returning no lines, began with a
>    select
> i.e. a line with leading spaces before the keyword "select"
> 
> Removing the spaces, the query got processed as expected, 
> returning n lines..

Thanks for this info Guido. As you noticed the extra spaces will cause this
problem (the beginning of the query is checked to determine whether rows are
expected back from the server). I will fix this right away...

Regards, Dave.