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

Re: [GENERAL] Using results from DELETE ... RETURNING

From: David Fetter <david(at)fetter(dot)org>
To: Petr Jelinek <pjmodos(at)pjmodos(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] Using results from DELETE ... RETURNING
Date: 2009-06-14 22:24:19
Message-ID: 20090614222419.GG15314@fetter.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Sun, Jun 14, 2009 at 05:59:58PM +0200, Petr Jelinek wrote:
> David Fetter wrote:
>> I was discussing this with Andrew Gierth in IRC, who thought that
>> putting RETURNING inside the WITH clause would be relatively easy, at
>> least for the parser and planner.  For the executor, he suggested that
>> one approach might be to make INSERT, UPDATE and DELETE into their own
>> nodes.
>
> David asked me to post his (and mine) experimental work in progress  
> patch for this here. The patch in the current state does not work. It  
> dies in executor on:
> ERROR:  attribute 1 has wrong type
> DETAIL:  Table has type tid, but query expects integer.
> Since I know nothing about postgres' executor I am only guessing it  
> thinks the query is SELECT instead of DELETE RETURNING.
> Also I think those query->commandType == CMD_SELECT ? query->targetList  
> : query->returningList in several places might not be the right way to 
> go.

I went another way in the attached patch, and thanks :)

> Anyway it's beginning and maybe somebody who knows what he is doing  
> could help or continue the work.

This patch fails regression tests and hangs or crashes when attempting
to do a writeable CTE.

Any help getting it into better shape would be greatly appreciated :)

Cheers,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2009-06-15 01:11:41
Subject: Re: machine-readable explain output
Previous:From: Erik RijkersDate: 2009-06-14 20:31:48
Subject: 8.4 release notes "Recursive Joins"

pgsql-general by date

Next:From: Tom LaneDate: 2009-06-14 22:36:33
Subject: Re: running pg_dump from python
Previous:From: Garry SaddingtonDate: 2009-06-14 21:50:32
Subject: Re: running pg_dump from python

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