Re: plpgsql replication stored procedure

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

aaron(dot)clauson(at)gmail(dot)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.

There is no way to write such a generic trigger in plpgsql (and even if
you could, its performance would suck :-().  You could do it in C if
you're sufficiently determined.

			regards, tom lane