Re: Explain verbose query with CTE - Mailing list pgsql-general

From Tom Lane
Subject Re: Explain verbose query with CTE
Date
Msg-id 17654.1335405425@sss.pgh.pa.us
Whole thread Raw
In response to Explain verbose query with CTE  (Bartosz Dmytrak <bdmytrak@gmail.com>)
Responses Re: Explain verbose query with CTE  (Bartosz Dmytrak <bdmytrak@gmail.com>)
List pgsql-general
Bartosz Dmytrak <bdmytrak@gmail.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

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: How can I see if my code is "concurrency safe"?
Next
From: Chris Travers
Date:
Subject: Re: How can I see if my code is "concurrency safe"?