Re: plpgsql replication stored procedure
| От | William Leite Araújo |
|---|---|
| Тема | Re: plpgsql replication stored procedure |
| Дата | |
| Msg-id | bc63ad820604171335m8325673maf2d64648361a465@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: plpgsql replication stored procedure (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-general |
On 4/17/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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.
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 ;-)
--
William Leite Araújo
Especialista em Geoprocessamento - UFMG
Bacharel em Ciêncida da Computação - UFMG
MSN: ufmgwil@yahoo.com.br
ICQ: 222159351
GTalk: william.bh@gmail.com
Yahoo: ufmgwil@yahoo.com.br
Skype: william.bh
В списке pgsql-general по дате отправления: