Re: query returning no lines - Mailing list pgadmin-support

From Guido Notari
Subject Re: query returning no lines
Date
Msg-id 000b01c1565c$175ac850$2f64a8c0@linkit
Whole thread Raw
List pgadmin-support
> 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..

    Ciao
        Guido



pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: pgAdmin II v1.1.59 Preview Release
Next
From: "Guido Notari"
Date:
Subject: query returning no lines