Re: insert ... delete ... returning ... ?

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Mark Mielke" <mark(at)mark(dot)mielke(dot)cc>, Postgresql-Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: insert ... delete ... returning ... ?
Date: 2008-02-24 23:14:33
Message-ID: 36e682920802241514l4ce3454bvd2d84112a494cc27@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Feb 24, 2008 at 5:44 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com> writes:
> > Not stupid, it doesn't work :) This was a limitation of the original
> > design based on (IIRC) executor-related issues.
>
> There are definitional issues not only implementation ones; in
> particular, in subquery-like cases it's entirely unclear how many times
> the DML operation will or should get evaluated.

Yup,that's what it was. I think I remember the trigger-level and
top-level executor-related stuff. If I'm in that area of the code
soon, I'll see how much would be involved and if I think I have enough
time, submit a proposal for it.

--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Mielke 2008-02-24 23:52:30 Re: insert ... delete ... returning ... ?
Previous Message Tom Lane 2008-02-24 22:44:52 Re: insert ... delete ... returning ... ?