| From: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Explain query |
| Date: | 2012-04-20 20:10:18 |
| Message-ID: | CAD8_Ucbso3wt1ssN2Z9k2mO1WuzhSdxTRco_GLwV5n13A3WZuw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
2012/4/20 Guillaume Lelarge <guillaume(at)lelarge(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2012-04-20 20:22:23 | Re: Explain query |
| Previous Message | Colin Beckingham | 2012-04-20 14:25:35 | Re: dev 1.15, wxw 2.9.3 - index column name truncated by 1 char |