UPDATE TRIGGER on view WAS: Re: Relation in tables

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Cc: "PFC" <lists(at)boutiquenumerique(dot)com>
Subject: UPDATE TRIGGER on view WAS: Re: Relation in tables
Date: 2005-02-16 20:48:56
Message-ID: 20050216204358.M29214@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, 16 Feb 2005 19:56:25 +0100, PFC wrote
> [snip] Use UPDATE triggers on the
> views, which in fact write to the products table [snip]

You can DO that!?!

Are you saying that a client can DELETE or INSERT or UPDATE a view and through
a trigger you can make this happen? Way cool. Can you provide a simple example?

And all this time I thought that you couldn't write to a view.

Kind Regards,
Keith

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Geoffrey 2005-02-16 20:51:00 Re: Order of columns in a table important in a stored procedure?
Previous Message T- Bone 2005-02-16 20:16:36 Comments on subquery performance