Re: Field collection in trigger

Поиск
Список
Период
Сортировка
От Josué Maldonado
Тема Re: Field collection in trigger
Дата
Msg-id 3F53A192.1070706@lamundial.hn
обсуждение исходный текст
Ответ на Re: Field collection in trigger  (Doug McNaught <doug@mcnaught.org>)
Ответы Re: Field collection in trigger  (darren@crystalballinc.com)
Список pgsql-general
Hi Doug,

Thanks for anwsers, do you have some sample code or URL where I can get
more info on this. I don't know C or Perl but really need to get this done.

Thanks,

Doug McNaught wrote:

>Josué Maldonado <josue@lamundial.hn> writes:
>
>
>
>>Hello list,
>>
>>First of all, excuse me if this is not the right place to ask my question.
>>
>>Is there a way in postgresql to loop to all the fields of a  given
>>table and compare the OLD and NEW value for each field. I need to make
>>an audit table that must contain only the fields changed after and
>>insert/update.
>>
>>
>
>You should be able to do this in a Perl or C trigger.  It can't be
>done in PL/pgSQL without writing a custom trigger for each table that
>hard-codes all the field names.
>
>-Doug
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>
>



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

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: Field collection in trigger
Следующее
От: apb18@cornell.edu
Дата:
Сообщение: Re: Field collection in trigger