Re: Adding MERGE to the TODO list (resend with subject) - Mailing list pgsql-hackers

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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073