Re: Explain query

Поиск
Список
Период
Сортировка
От Bartosz Dmytrak
Тема Re: Explain query
Дата
Msg-id CAD8_Ucbso3wt1ssN2Z9k2mO1WuzhSdxTRco_GLwV5n13A3WZuw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Explain query  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Explain query
Список pgadmin-support

2012/4/20 Guillaume Lelarge <guillaume@lelarge.info>
I tried on PostgreSQL 9.2dev, and I get the same error without using
pgAdmin. So the problem is within PostgreSQL, not pgAdmin. I only have
the error if I use the VERBOSE option. EXPLAIN, and EXPLAIN ANALYZE
without verbose work great. So I guess you should complain on
pgsql-general.
sure - thanks for Your time.

BTW, your query is kinda weird to me. You declare a CTE named t that you
do not use. And it still gets executed. Kinda puzzling.

this was only POC, I am going to use CTE (t) with update, but I faced this problem and then I simplified the query as much as possible. 

Regards,
Bartek 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Colin Beckingham
Дата:
Сообщение: Re: dev 1.15, wxw 2.9.3 - index column name truncated by 1 char
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Explain query