Dynamic Log tigger (plpgsql)
От | Noah Heusser |
---|---|
Тема | Dynamic Log tigger (plpgsql) |
Дата | |
Msg-id | 4673C901.2000806@heussers.ch обсуждение исходный текст |
Ответы |
Re: Dynamic Log tigger (plpgsql)
Re: Dynamic Log tigger (plpgsql) Re: Dynamic Log tigger (plpgsql) |
Список | pgsql-general |
Hi I want to implement a trigger-function witch can fill the following table. Each data manipulation (INSERT, UPDATE or DELETE) gets logged. The function should work as trigger on diffrent tables. CREATE TABLE logtable ( operation CHAR(6) CHECK (change_type IN ('DELETE', 'INSERT', 'UPDATE')), tablename VARCHAR, rowid INTEGER, - touched_columns VARCHAR[] ); My Problem is in the last Column (touched_columns). If it was an UPDATE Operation, I just need to know witch columns changed. (I am not iterrestet in the old or new value) => IF OLD.columnName != NEW.columnName, it has changed. My Question: How can I do "OLD.columnName != NEW.columnName" if I don't know what the columnNames are at Compile Time? I have the columnName in a variable. Thx for help. Noah
В списке pgsql-general по дате отправления: