Skip site navigation (1) Skip section navigation (2)

Re: Using results from INSERT ... RETURNING

From: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: PostgreSQL hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Using results from INSERT ... RETURNING
Date: 2009-08-29 23:18:34
Message-ID: 4A99B74A.2000801@cs.helsinki.fi (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

This WIP patch refactors the executor by creating nodes for DML (INSERT,
UPDATE, DELETE). It is designed both to clean up the executor and to
help with making it possible to use (INSERT|UPDATE|DELETE) ...RETURNING
inside a WITH clause. At first I thought about removing
PlannedStmt::returningLists, but there are a couple of places where it's
still used, and having it there won't hurt so I didn't touch it.
ExecInitDml() could still be better.

Does anyone see something seriously wrong with it? Ideas and further
improvements are welcome too.

Attached to the upcoming commitfest.

Regards,
Marko Tiikkaja


Attachment: dmlnode.patch
Description: text/plain (71.0 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2009-08-29 23:28:14
Subject: Re: LWLock Queue Jumping
Previous:From: Adriano LangeDate: 2009-08-29 19:18:33
Subject: Re: Memory context usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group