Re: Allowing update of column only from trigger - Mailing list 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@tbc.net