From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
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 06:59:42 |
Message-ID: | 1084258782.4709.7.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
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.
---------------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Stijn Vanroye | 2004-05-11 07:24:46 | Re: Cancel query based on a timeout |
Previous Message | pw | 2004-05-11 03:35:43 | query of database to get permitted users list |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-05-11 13:44:26 | Re: Adding MERGE to the TODO list (resend with subject) |
Previous Message | Simon Riggs | 2004-05-11 06:44:53 | Re: XLog: how to log? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bernard Cheung | 2004-05-11 07:09:49 | Re: Trigger function to know which fields are being updated |
Previous Message | Andrei Bintintan | 2004-05-11 06:02:19 | Re: Exceptions when 0 rows affected. |