aaron.clauson@gmail.com writes: > I'm trying to write a stored procedure that can capture all the changes > to a table and record the changes based on the table's primary key. > I can almost get there but the sticking point is being able to access > the primary key field of the NEW/OLD record in the trigger stored > procedure without knowing it's name.
My database has a table that store all changes mades on all tables. The insert is made by onde single trigger, but I create a function that build functions to convert an generic record on a text value. If this is usefull, mail-me ;-)
Dynamic record name cannot be made on a plpgsql function. This topic was discursed some months ago.