Re: TRIGGER with WHEN clause

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "KaiGai Kohei *EXTERN*" <kaigai(at)kaigai(dot)gr(dot)jp>, "Itagaki Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <gsql-rrreviewers(at)postgresql(dot)org>
Subject: Re: TRIGGER with WHEN clause
Date: 2009-11-16 10:42:37
Message-ID: D960CB61B694CF459DCFB4B0128514C203938039@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-rrreviewers

KaiGai Kohei wrote:
> I'm uncertain how Oracle handles the condition on the statement
> triggers. But it seems to me WHEN clause on the statement triggers
> are nonsense.

SQL> CREATE TRIGGER dummy BEFORE DELETE ON employees WHEN (1 = 1)
2 BEGIN
3 END;
4 /
CREATE TRIGGER dummy BEFORE DELETE ON employees WHEN (1 = 1)
*
ERROR at line 1:
ORA-04077: WHEN clause cannot be used with table level triggers

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Boszormenyi Zoltan 2009-11-16 10:58:04 ECPG patch 1, dynamic cursorname
Previous Message Tatsuo Ishii 2009-11-16 10:06:27 Re: Summary and Plan for Hot Standby

Browse pgsql-rrreviewers by date

  From Date Subject
Next Message KaiGai Kohei 2009-11-16 11:03:24 Re: TRIGGER with WHEN clause
Previous Message Bernd Helmle 2009-11-16 09:12:50 Re: CommitFest 2009-11: Initial assignments