From: | "Gerhard Dieringer" <DieringG(at)eba-haus(dot)de> |
---|---|
To: | <admin(at)wtbwts(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Antw: [SQL] attribute level rules not supported? |
Date: | 2000-01-17 08:12:53 |
Message-ID: | s882dd23.015@kopo001 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
>>> Marc Tardif <admin(at)wtbwts(dot)com> 16.01.2000 14.20 Uhr >>>
> Here's the problem:
> test=> CREATE TABLE a ( refb OID, at INT2 );
> test=> CREATE TABLE b ( refa OID, bt INT2 );
> test=> CREATE RULE ar AS ON UPDATE TO a.at
> test-> DO UPDATE b SET b.bt = NEW.at
> test-> WHERE refa = OLD.oid;
> ERROR: attribute level rules currently not supported
> What am I doing wrong? I've read and re-read chapter 8 - rules from the
> postgresql programmer's guide, but I can't see why this rule doesn't work.
> Any suggestions would be appreciated.
>
> Marc
Try:
CREATE RULE ar AS ON UPDATE TO a DO UPDATE b .....
I think you you should speciify the table a, not the attribute a.at.
Gerhard
From | Date | Subject | |
---|---|---|---|
Next Message | Marten Feldtmann | 2000-01-17 19:29:34 | index usage ... strange !? |
Previous Message | Tom Lane | 2000-01-16 17:35:34 | Re: [SQL] numeric question.. |