From: | Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com> |
---|---|
To: | PostgreSQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | More than 1 trigger of the same kind |
Date: | 2002-11-09 03:35:33 |
Message-ID: | 20021109033533.20773.qmail@web80313.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi:
Can I have more than 1 trigger of same kind on one
table? (i.e. 2 AFTER INSERT TRIGGER) on 1 table?
I'm planning to split up a large trigger function
(about 200 lines) into 2 seperate triggers. Since
PL/PGSQL functions cannot accepts OPAQUE as arguments,
I have to create 2 triggers instead of just creating 2
functions and having the trigger function calling
another function passing the record NEW and OLD.
Does having more than 1 trigger of the same kind
produces some side effect? I mean is the order of the
trigger firing is always the same?
Thank you in advance,
ludwig.
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-11-09 03:49:52 | Re: More than 1 trigger of the same kind |
Previous Message | Ludwig Lim | 2002-11-09 02:50:41 | Passing OLD/NEW as composite type PL/PGSQL |