Re: query returning no lines

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Guido Notari'" <gnotari(at)linkgroup(dot)it>, pgadmin-support(at)postgresql(dot)org
Subject: Re: query returning no lines
Date: 2001-10-16 19:08:26
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00BB8@dogbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message Wendt, Marian 2001-10-16 19:58:47 Save DB Schema
Previous Message Guido Notari 2001-10-16 16:03:27 Re: query returning no lines