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.
