Trigger set to backup to other table NOT FUNCTIONING...
От | Joepie Platteau |
---|---|
Тема | Trigger set to backup to other table NOT FUNCTIONING... |
Дата | |
Msg-id | 414570D2.9090405@kulak.ac.be обсуждение исходный текст |
Ответы |
Re: Trigger set to backup to other table NOT FUNCTIONING...
|
Список | pgsql-admin |
Hi, I have a problem with my trigger... : my tables : CREATE TABLE public."T-Alumni" ( "Id_Persoon" int8 DEFAULT nextval('"T-Alumni_Id_Persoon_seq"'::text) NOT NULL, "SteunendLid" bool, "Betaald" bool, "Stamnr" int4, "Alumninr" int4, "Acjaar" varchar(50), "Studiejaar" varchar(50), CONSTRAINT "T-Alumni_pkey" PRIMARY KEY ("Id_Persoon") ) WITH OIDS; CREATE TABLE public."T-Alumni-backup" ( "Id_Persoon" int8 NOT NULL, "SteunendLid" bool, "Betaald" bool, "Stamnr" int4, "Alumninr" int4, "Acjaar" varchar(50), "Studiejaar" varchar(50) ) WITH OIDS; i have a table (T-Alumni) and BEFORE a record changes or is being deleted, I want to copy this record to a UNDO_table (T-Alumni-backup). I tried like this : CREATE FUNCTION public.f100() RETURNS trigger AS ' BEGIN INSERT INTO "T-Alumni-backup" VALUES (NEW.Id_Persoon, NEW.SteunendLid, NEW.Betaald, NEW.Stamnr, NEW.Alumninr, NEW.Acjaar, NEW.Studiejaar); RETURN NEW; END; ' LANGUAGE 'plpgsql' VOLATILE; CREATE TRIGGER t100t BEFORE DELETE OR UPDATE ON public."T-Alumni" FOR EACH ROW EXECUTE PROCEDURE f100(); I get this error : Record "new" has no field "id_persoon" (#7) Also I want to have the name of the person who deleted or changed the record in my BackUp (undo) table... Can someone tell me how to solve this problem? Thanx! Joepie.
В списке pgsql-admin по дате отправления: