Triggers and User Defined Trigger Functions
От | Gordan Bobic |
---|---|
Тема | Triggers and User Defined Trigger Functions |
Дата | |
Msg-id | 422EDA51.6080903@bobich.net обсуждение исходный текст |
Ответы |
Re: Triggers and User Defined Trigger Functions
|
Список | pgsql-general |
Hi, I'm trying to figure out how to do this from the documentation, but I can't figure it out. :-( Here is what I'm trying to do: CREATE TABLE MyTable ( ID bigserial unique, MyData char(255), PRIMARY KEY (ID) ); CREATE TABLE Archive_MyTable ( ID bigserial unique, MyData char(255), PRIMARY KEY (ID) ); CREATE FUNCTION MyTable_Trigger_DELETE() RETURNS ???opaque/trigger/HeapTuple??? AS ' INSERT INTO Archive_MyTable ( ID, MyData ) VALUES ( OLD.ID, OLD.MyData ); RETURN OLD; ' LANGUAGE SQL; This gives me one of the following errors: ERROR: SQL functions cannot return type opaque ERROR: SQL functions cannot return type "trigger" ERROR: type "heaptuple" does not exist What type should my function be returning? ERROR: type Then I'd like to do the following: CREATE TRIGGER MyTable_Trigger_DELETE BEFORE DELETE ON MyTable FOR EACH ROW EXECUTE PROCEDURE MyTable_Trigger_DELETE(); Can I create a trigger function like this? If not, what are my options WRT alternatives? Many thanks. Gordan
В списке pgsql-general по дате отправления: