Postgres Pro
Downloads
Home   >   mailing lists

Re: Writeable CTEs and side effects - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Writeable CTEs and side effects
Date
Msg-id 1255028233.16369.100.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to Re: Writeable CTEs and side effects  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Writeable CTEs and side effects  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Thu, 2009-10-08 at 12:57 -0400, Tom Lane wrote:
> I also agree with bumping the CID in between.

Do you mean bump the CID in between each DML statement, or between the
last DML statement and the main query? If the former, how should we
choose the order of execution?

I'm not sure if this is a problem, but it seems like we're essentially
allowing a complex transaction to take place in one statement. Is that
what we want?

Regards,Jeff Davis

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using results from INSERT ... RETURNING
Next
From: Alvaro Herrera
Date:
Subject: Re: Using results from INSERT ... RETURNING