Insert Updates Deletes on Views; Triggers on System Tables

Поиск
Список
Период
Сортировка
От Raymond
Тема Insert Updates Deletes on Views; Triggers on System Tables
Дата
Msg-id 200307121322.01512.support@bigriverinfotech.com
обсуждение исходный текст
Ответы Returning tablename.column?  (Kurt Overberg <kurt@hotdogrecords.com>)
Re: Insert Updates Deletes on Views; Triggers on System Tables  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-general
New to Postgres so please excuse my ignorance.

1) Are inserts, updates and deletes on views permissible?

2) Can triggers be applied to system tables ( pg_group)?

The reason for 2) is that each user MUST belong to ONLY one of six groups So I
believe a before-trigger is required to enforce this rule. And speaking of
rules, cannot utilize the Postgres rules system (presume similiar to Apache
rewrite engine) as database MUST remain very "traditional Oracle"  centric;
hence the functions, triggers, etc.

Raymond

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

Предыдущее
От: "Zeno Davatz"
Дата:
Сообщение: Re: corrupt data
Следующее
От: weigelt@metux.de
Дата:
Сообщение: Re: [pgsql-advocacy] MySQL gets $19.5 MM