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>
pgAdmin. So the problem is within PostgreSQL, not pgAdmin. I only haveI tried on PostgreSQL 9.2dev, and I get the same error without using
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 по дате отправления: