bug or feature? (regarding rules)

From: Jeff Hoffmann <jeff(at)propertykey(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: bug or feature? (regarding rules)
Date: 2000-05-31 19:47:37
Message-ID: 39356C59.4F04A9CF@propertykey.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

this is a pretty minor thing, but i just dropped a table that is acted
on by a rule declared as part of another table and i'm wondering if this
is the expected (or more importantly the desired) behavior. basically
the rule deletes all of the rows of table two with same id as was
deleted in table one. when i drop table two, it lets me do it without
any notice of there being a rule that affects this table & then when i
try to do a delete on table one, it gives me an error. i'm not sure how
other databases handle this, but it seems to me that i should have at
least been warned that there is a dependency there when i dropped the
table if not being disallowed from dropping the table altogether until i
drop the rule.

jeff

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-05-31 20:46:01 more cvs problems
Previous Message Bruce Momjian 2000-05-31 19:43:10 Re: config files in /data