Re: Allowing update of column only from trigger

From: Shawn Harrison <harrison(at)tbc(dot)net>
To:
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Allowing update of column only from trigger
Date: 2005-01-31 18:59:16
Message-ID: 41FE8004.4070700@tbc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Shawn Harrison wrote [01/31/05 12:56 PM]:
> Shawn Harrison wrote [01/28/05 3:53 PM]:
> create or replace rule objects__update as on update to objects
> do instead (
> update objects_data set
> name = new.name,
> typename = new.typename,
> parent = new.parent,
^^^^
This is a simplified version of the rule; the real one didn't have this
syntax error.

> where id = new.id
> );
> ...
--
________________
harrison(at)tbc(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2005-01-31 19:00:06 Re: Howto determin the number of elemnts of an array
Previous Message Shawn Harrison 2005-01-31 18:55:22 Re: Allowing update of column only from trigger