Re: Is this correct behavior for ON DELETE rule?

Rick Schumeyer wrote:
> I tried that, but I get a "...violates foreign-key constraint" error.

Oh, sorry.

---------------------------------------------------------------------------

>
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> > owner(at)postgresql(dot)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;
> > > );
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073