Insert Updates Deletes on Views; Triggers on System Tables - Mailing list pgsql-general

From Raymond
Subject Insert Updates Deletes on Views; Triggers on System Tables
Date
Msg-id 200307121322.01512.support@bigriverinfotech.com
Whole thread Raw
Responses Returning tablename.column?  (Kurt Overberg <kurt@hotdogrecords.com>)
Re: Insert Updates Deletes on Views; Triggers on System Tables  (Andrew Sullivan <andrew@libertyrms.info>)
List 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 by date:

Previous
From: "Zeno Davatz"
Date:
Subject: Re: corrupt data
Next
From: weigelt@metux.de
Date:
Subject: Re: [pgsql-advocacy] MySQL gets $19.5 MM