Rick Schumeyer wrote: > I tried that, but I get a "...violates foreign-key constraint" error.
Oh, sorry. --------------------------------------------------------------------------- > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:pgsql-general- > > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
