Re: Is this correct behavior for ON DELETE rule? - Mailing list pgsql-general

I tried that, but I get a "...violates foreign-key constraint" error.

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Bruce Momjian
> Sent: Friday, February 25, 2005 6:23 PM
> To: Rick Schumeyer
> Cc: 'PgSql General'
> Subject: Re: [GENERAL] Is this correct behavior for ON DELETE rule?
>
>
> Uh, because of your REFERENCES clause you have to delete from 'item'
> first, then 'book':
>
> > -- delete to item and book instead of bookview
> > create rule bookviewdel as on delete to bookview do instead (
> >       delete from item where id=old.id;
> >       delete from book where id=old.id;
> > );
>