inheriting a rule or a trigger?

Поиск
Список
Период
Сортировка
От Louis-David Mitterrand
Тема inheriting a rule or a trigger?
Дата
Msg-id 20070724143737.GA25948@apartia.fr
обсуждение исходный текст
Ответы Database synchronization  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
Список pgsql-sql
Hi,

I'm trying to protect created_by and created_on columns from accidental 
update. Most of my tables inherit from a 'source' table that has those 
columns, so I was thinking of creating a rule or trigger that does 
nothing on update to these columns. But apparently rules and triggers 
don't apply to child tables.

Is there another way to have the same effect, short of a rule/trigger on 
each table?


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

Предыдущее
От: "Peter Childs"
Дата:
Сообщение: Re: is there a 'table' data type in pg?
Следующее
От: "Jyoti Seth"
Дата:
Сообщение: Database synchronization