Alfred Perlstein <bright@wintelcom.net> writes:
> Ok, typo on my part, if you type "DROP VIEW foo;" that nukes the rule and
> the table behind it. Is that the expected behavior?
Well, yeah: a view *is* a table + ON SELECT rule, at least in current
releases. Mark Hollomon just submitted a patch that would create a
distinction, but it's not even been applied to CVS yet...
regards, tom lane