create trigger on view

Поиск
Список
Период
Сортировка
От Camm Maguire
Тема create trigger on view
Дата
Msg-id 541y4fnokv.fsf_-_@intech19.enhanced.com
обсуждение исходный текст
Список pgsql-hackers
Greetings!  Somewhere between 7.1 and 7.2, creating triggers on insert
to a view has been disallowed.  The docs still report it as a
possibility -- see rules vs. triggers.  Worse, we have a postgres
database relying on this feature for several years now.  What can I
do?  I suppose I could use a rule, but all the insert rule examples I
can find in the docs have simple sql do instead clauses, whereas my
trigger called a rather involved plsql function.  

Advice most appreciated.

Take care,


-- 
Camm Maguire                             camm@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens."  --  Baha'u'llah


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Table Timemachine!
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: v7.3.1 tar ready ... please check it ...