Insert Updates Deletes on Views; Triggers on System Tables

From: Raymond <support(at)bigriverinfotech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Insert Updates Deletes on Views; Triggers on System Tables
Date: 2003-07-12 20:22:01
Message-ID: 200307121322.01512.support@bigriverinfotech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-07-12 20:33:43 Re: Insert Updates Deletes on Views; Triggers on System Tables
Previous Message Zeno Davatz 2003-07-12 19:47:16 Re: corrupt data