I am trying to set up my first trigger event without success, this is
what i am trying to do.
I have information that is inserted from MS SQL SERVER into the main
cs_levels which resides on Postgres 8.1 on our Linux Red Hat Server.
a row is inserted into the cs_levels table I want a Trigger after
Insert to run
and then insert the 10 variables on that row into the archive table. I
worked with triggers before but apparently i cannot pass variables into
function, so how can i do an insert? I noticed a section on specific
for trigger functions but its not very clear.
I could just run the insert query twice from MS SQL Server but i have
triggers in other places and guessed i might as well face the music
pgsql-novice by date
|Next:||From: Keith D. Evans||Date: 2006-06-29 22:27:53|
|Subject: number characters on the command line|
|Previous:||From: nitin quick||Date: 2006-06-29 03:17:29|
|Subject: Re: postgres in realtime mode|