Re: [SQL] example of trigger to track DB changes

Поиск
Список
Период
Сортировка
От Brook Milligan
Тема Re: [SQL] example of trigger to track DB changes
Дата
Msg-id 199906151911.NAA28058@trillium.nmsu.edu
обсуждение исходный текст
Ответ на example of trigger to track DB changes  (Michael Olivier <mo@local2me.com>)
Ответы Re: [SQL] example of trigger to track DB changes
Список pgsql-sql
I've looked through the trigger examples in the html doc and the src  tree but didn't find the one I was looking
for.

Look in the rules docs instead.
  I want to set up a trigger to track changes (add/update/delete) to rows  in two tables.  This can be through
insertingOID's or acctname's  (acctname of web users) into a "changed_rows" table that keeps track of  changed rows.
 
  Would someone provide some source code that does this?  I'm assuming a  lot of people have done this... I'm using
6.3.2...
 

The rules docs describe how to do exactly this and give an example.

Cheers,
Brook


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

Предыдущее
От: Charles
Дата:
Сообщение: Maybe a bug with SQL processor
Следующее
От: Dipankar Chakrabarti
Дата:
Сообщение: pg_dump