Re: trigger postgresql 7.4

am Thu, dem 19.10.2006, um 2:49:23 -0700 mailte Daniel(dot)Chmielewski(at)gmail(dot)com folgendes:
> Hi,
> I have a question connected with postgres procedural langauge. Version
> of Postgres:
>
> "PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc"

Outdated.

>
> I have a table on which I have created many triggers on the same event
> BEFORE UPDATE.
>
> I have 3 these triggers. In each of this trigger I have a statement
> RETURN NEW or ''RAISE EXCEPTION".
>
> My question is:
> 1. In which order (first, second, third) each trigger is executed?
> I think that triggers are executed in order by oid or by name. Tell me
> please.

By name, alphabetically.

>
> 2. Is it possible that next trigger on the same event is not executed
> when the previous one has returned "RETURN NEW"?

IIRC no.

>
> 3. The last question is, is there any debbuger to debugg triggers in
> plpgsql? This could be very usefull.

You can throw RAISE NOTICE...

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net