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

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