Re: [GENERAL] plpgsql replication stored procedure

2006-04-17 Thread Peter Wilson
[EMAIL PROTECTED] wrote: Hi, 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 trigg

Re: [GENERAL] plpgsql replication stored procedure

2006-04-17 Thread William Leite Araújo
On 4/17/06, Tom Lane <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] 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 primar

Re: [GENERAL] plpgsql replication stored procedure

2006-04-17 Thread Tom Lane
[EMAIL PROTECTED] 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 trig

[GENERAL] plpgsql replication stored procedure

2006-04-17 Thread aaron . clauson
Hi, 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