The following bug has been logged online:

Bug reference: 1767
Logged by: THILANKA
Email address: tilankaedu (AT) yahoo (DOT) com
PostgreSQL version: suse 9.0 builti
Operating system: SUSE LINUX
Description: Trigger handling
Details:

Here is the my question.

I tried to pass parameters to the trigger using "new" key word, but it's not
accepted. The purpose of doing that i want to pass some data to a "c" file
and to send the same data into a another database. So in that problem i
faild. If u know how to do that pls send me the way.

thank you......

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

On 7/13/05, THILANKA <tilankaedu (AT) yahoo (DOT) com> wrote:
Triggers doesn't accept parameters at runtime.=20

taken from: http://www.postgresql.org/docs/8.0/s...tetrigger.html

CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] }
ON table [ FOR [ EACH ] { ROW | STATEMENT } ]
EXECUTE PROCEDURE funcname ( arguments )

arguments
An optional comma-separated list of arguments to be provided to the
function when the trigger is executed. The arguments are literal
string constants. Simple names and numeric constants may be written
here, too, but they will all be converted to strings. Please check the
description of the implementation language of the trigger function
about how the trigger arguments are accessible within the function; it
may be different from normal function arguments.

--=20
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org