On 7/13/05, THILANKA <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1767 > Logged by: THILANKA > Email address: [EMAIL PROTECTED] > 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. >
Triggers doesn't accept parameters at runtime. taken from: http://www.postgresql.org/docs/8.0/static/sql-createtrigger.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. -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
