Re: Adding MERGE to the TODO list (resend with subject)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, elein <elein(at)varlena(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Adding MERGE to the TODO list (resend with subject)
Date: 2004-05-11 13:44:26
Message-ID: 200405111344.i4BDiQj06463@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

Hannu Krosing wrote:
> Bruce Momjian kirjutas T, 11.05.2004 kell 00:26:
> > Hannu Krosing wrote:
> > > Bruce Momjian kirjutas E, 10.05.2004 kell 06:58:
> > > > Added to TODO:
> > > >
> > > > * Add MERGE command that does UPDATE, or on failure, INSERT
> > >
> > > perhaps the issue raised about BEFOR/AFTER INSERT/UPDATE TRIGGERS and
> > > RULES should get a mention in the TODO (... needs to be discussed, or
> > > somesuch ...)
> >
> > Uh, what was the issue there?
>
> I think it is not well defined, which triggers should be run. For
> example, should BEFORE UPDATE trigger be run and should INSERT be done
> if BEFORE UPDATE forbids UPDATE.
>
> Also how should the rule system act - should there be separate rules for
> MERGE, or/and should MERGE be expanded by both UPDATE and INSERT rules.

OK, I added information to TODO questioning how to handle rules and
triggers.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Maciej Bliziński 2004-05-11 14:22:55 Re: Trying to compute the median
Previous Message Tom Lane 2004-05-11 13:22:43 Re: Trying to compute the median

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2004-05-11 13:56:26 Re: XLog: how to log?
Previous Message Hannu Krosing 2004-05-11 06:59:42 Re: Adding MERGE to the TODO list (resend with subject)

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Eckermann 2004-05-11 13:59:03 Re: Trigger function to know which fields are being updated
Previous Message Willem de Jong 2004-05-11 08:08:34 Seconds To Time