Re: Explain verbose query with CTE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Explain verbose query with CTE
Date: 2012-04-26 01:57:05
Message-ID: 17654.1335405425@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> writes:
> [ EXPLAIN VERBOSE fails for ]
> WITH t as (
> INSERT INTO "tblD1" (id, "Data1")
> VALUES ('a', 123)
> RETURNING *)
> UPDATE "tblBase"
> SET "SomeData" = 123
> WHERE id = 'a';

I've applied a patch for this. Thanks for the report!

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2012-04-26 01:59:28 Re: How can I see if my code is "concurrency safe"?
Previous Message David Johnston 2012-04-26 01:05:50 Re: How can I see if my code is "concurrency safe"?