subject:"\[SQL\] Insert with pl\/pgsql trigger"

Re: [SQL] Insert with pl/pgsql trigger

2008-05-07 Thread Tom Lane

"Woody Woodring" <[EMAIL PROTECTED]> writes: > My trigger is : > CREATE OR REPLACE FUNCTION log_cpe_health() RETURNS trigger AS ' >DECLARE >BEGIN > -- Update last outage before inserting > EXECUTE ''INSERT INTO cpe_health_history VALUES '' || NEW; >END; > ' LANGUAGE plpgsql;

[SQL] Insert with pl/pgsql trigger

2008-05-07 Thread Woody Woodring

I am trying to create a table that is a log of another table in 8.3.1 using a trigger. Both tables look like Table "public.cpe_health_history" Column|Type| Modifiers --++--- cpe_healthid | integer| not null mac | macaddr| po