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

From Andrew Sullivan
Subject Re: Insert Updates Deletes on Views; Triggers on System Tables
Date
Msg-id 20030715134244.GA27367@libertyrms.info
Whole thread Raw
In response to Insert Updates Deletes on Views; Triggers on System Tables  (Raymond <support@bigriverinfotech.com>)
List pgsql-general
On Sat, Jul 12, 2003 at 01:22:01PM -0700, Raymond wrote:
> 1) Are inserts, updates and deletes on views permissible?

Yes, but you need to write rules for this.  Momjian's book (available
from A-W, I believe, or through the PostgreSQL web site) has a
discussion of how to do it.

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

No.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: "Chris Boget"
Date:
Subject: Re: Are you frustrated with PostgreSQL
Next
From: John Bercik
Date:
Subject: Billions of records?