2012/4/20 Guillaume Lelarge <guilla...@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