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@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;
> > > );
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

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