|
i am currently migrating a db from Oracle to Pg and in some
of my triggers i use variables, i.e. i have some thing like this: [Oracle version] CREATE OR REPLACE TRIGGER "USERACTION_VIEW"
INSTEAD OF INSERT ON "USERACTION_VIEW" DECLARE UserActionID INTEGER; UserActionDataID INTEGER; begin SELECT USERACTION_SQ.nextval into UserActionID FROM DUAL; SELECT USERACTIONDATA_SQ.nextval into UserActionDataID FROM
DUAL; INSERT INTO USERACTION ( UserActionID, LocalID, UserActionTypeID, ActionDate ) VALUES ( UserActionID, :new.LocalID, :new.UserActionTypeID, SYSDATE ); INSERT INTO USERACTIONDATA ( UserActionDataID, UserActionID, AccountID, CourseRecordID, CourseRecordPaymentID, StudentID, CourseRecordTestID, CourseRecordLessonID ) VALUES ( UserActionDataID, UserActionID, :new.AccountID, :new.CourseRecordID, :new.CourseRecordPaymentID, :new.StudentID, :new.CourseRecordTestID, :new.CourseRecordLessonID ); end; so basically i have two variables here, UserActionID and
UserActionDataID. so when i am porting to PostgreSQL i will need to make this a
rule since Pg triggers only work for tables. The problem though is that i don't
know how to use variabvles in Pg rules. Any ideas? Is it possible at all? Thanks. |
