From: | thomas at tada(dot)se (Thomas Hallgren) |
---|---|
To: | |
Subject: | [Pljava-dev] Cancelling trigger operation |
Date: | 2006-10-23 08:46:27 |
Message-ID: | 453C8163.8090100@tada.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi Filip,
Something is definitely missing in the TriggerData interface. It should
have a 'setCancelled()' method that causes the returned tuple to be
null. Please add a bug for this.
Regards,
Thomas Hallgren
Filip Hrbek wrote:
> Hi Thomas,
>
> when a trigger function is written in pl/pgsql, you can decide to cancel the
> operation in a trigger(defined as "before event") by returning null instead
> of "new", e.g.
>
> create function cancelling_trigger() returns trigger as
> '
> begin
> if new.num < 0 then
> -- cancel operation for negative numbers
> return null;
> else
> -- continue
> -- do something...
> return new;
> end if;
> end
> ' language 'plpgsql';
>
> Is there any way to do the same in pljava? I can't see it now, since the
> trigger functions are mapped to static java methods with no return values
> (void):
>
> public static void cancellingTrigger(TriggerData td) throws SQLException {
> if (td.getNew().getInt("num") < 0) {
> //Cancel operation - HOW???
> }
> else {
> //Continue
> //do something...
> }
> }
>
> Filip
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schaber | 2006-10-23 08:52:55 | [Pljava-dev] Cancelling trigger operation |
Previous Message | Filip Hrbek | 2006-10-23 08:02:42 | [Pljava-dev] Cancelling trigger operation |