From: | Daniel(dot)Chmielewski(at)gmail(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | trigger postgresql 7.4 |
Date: | 2006-10-19 09:49:23 |
Message-ID: | 1161251363.537701.231310@h48g2000cwc.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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"
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.
2. Is it possible that next trigger on the same event is not executed
when the previous one has returned "RETURN NEW"?
3. The last question is, is there any debbuger to debugg triggers in
plpgsql? This could be very usefull.
Please help,
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Rodrigo Sakai | 2006-10-19 10:51:17 | Interval referential integrity |
Previous Message | Georgi Petrov | 2006-10-19 08:42:48 | problems installing pg on solaris |