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

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 (view raw or flat)
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.

pgadmin-support by date

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

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