From: | Itai Zukerman <zukerman(at)math-hat(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Conditional rule? |
Date: | 2000-07-28 11:04:07 |
Message-ID: | 87zon2tt20.fsf@matt.w80.math-hat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> > CREATE RULE newsrule AS ON INSERT TO news
> > WHERE new.publishtime NOTNULL DO
> > INSERT INTO news_unpublished VALUES (new.id);
>
> The following happens:
> rules=# insert into news (title, time) values('Hei', now());
> ERROR: <unnamed> referential integrity violation - key referenced from
> news_unpublished not found in news
I noticed this, too.
More generally, I've found that whereas rules initially looked like a
great thing to use, in practice I have really no idea what they're
going to do. And I find their description in the programmer's guide
confusing. Is there any better rules tutorial out there?
-itai
From | Date | Subject | |
---|---|---|---|
Next Message | André Næss | 2000-07-28 11:46:51 | Re: Conditional rule? |
Previous Message | André Næss | 2000-07-28 09:40:26 | Re: BLOBs |