Re: hostory tables with a generic function?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: hostory tables with a generic function?
Дата
Msg-id 1409.1092171298@sss.pgh.pa.us
обсуждение исходный текст
Ответ на hostory tables with a generic function?  (Raphael Bauduin <raphael.bauduin@be.easynet.net>)
Список pgsql-general
Raphael Bauduin <raphael.bauduin@be.easynet.net> writes:
> - is it possible to write only one function used for all logging triggers?

Yes, but it will be very hard and inefficient (maybe even impossible)
in plpgsql.  plpgsql isn't intended for dynamic field access and you'll
really be fighting the language.

I'd suggest writing in C, perhaps after proofing in pltcl.

There are some sample C triggers in the contrib tree that do things
fairly close to this; you might try adapting one of those.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: PostgreSQL 8.0.0 Officially Goes Beta
Следующее
От: Jonathan Barnhart
Дата:
Сообщение: Transaction blocks