am Thu, dem 19.10.2006, um 2:49:23 -0700 mailte [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
