am Thu, dem 19.10.2006, um 2:49:23 -0700 mailte Daniel.Chmielewski@xxxxxxxxx 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
