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