Re: query returning no lines

Поиск
Список
Период
Сортировка
От Guido Notari
Тема Re: query returning no lines
Дата
Msg-id 000b01c1565c$175ac850$2f64a8c0@linkit
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: pgAdmin II v1.1.59 Preview Release
Следующее
От: "Guido Notari"
Дата:
Сообщение: query returning no lines