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

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

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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?

Browse pgsql-sql by date

  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.