Thread: query returning no lines

query returning no lines

From

"Guido Notari"

Date:

16 October 2001, 16:19:27

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.

Exactly the same query, executed on the same database, returns 8 rows
both in psql and in pgaccess -- verified copying and pasting it, reading
it from the same file, etc, etc.

I'm rather lost, am I overlooking something, or...?

    Ciao
        Guido

Re: query returning no lines

From

Dave Page

Date:

16 October 2001, 19:41:06


> -----Original Message-----
> From: Guido Notari [mailto:gnotari@linkgroup.it]
> Sent: 16 October 2001 17:03
> To: pgadmin-support@postgresql.org
> 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.