/* Once update function olusturulur */ CREATE OR REPLACE FUNCTION "dbo"."CandidateList_update_trigger_fnc"() RETURNS trigger LANGUAGE 'plpgsql' COST 100 VOLATILE NOT LEAKPROOF AS $BODY$ BEGIN INSERT INTO "dbo"."CandidateList_Repl" ( "Id","JobListId","CvNo","ResumeJson","ResumeSource","Status","CreateDate","LastModifyDat","ReviewDate","SameCompany","MailStatus","Operation" ) VALUES(NEW."Id", NEW."JobListId", NEW."CvNo", NEW."ResumeJson", NEW."ResumeSource", NEW."Status",NEW."CreateDate",NEW."LastModifyDat",NEW."ReviewDate",NEW."SameCompany",NEW."MailStatus",'U'); RETURN NEW; END; $BODY$;
ALTER FUNCTION "dbo"."CandidateList_update_trigger_fnc"() OWNER TO postgres;
/* Sonra Yukaridaki trigger foknsiyonu tetikleyen trigger tablo uzerine eklenir*/ CREATE TRIGGER "CandidateList_update_trigger" AFTER UPDATE ON "dbo"."CandidateList" FOR EACH ROW EXECUTE PROCEDURE "dbo"."CandidateList_update_trigger_fnc"()
