Re: Really bad/weird stuff with views over tables in 7.0.2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Really bad/weird stuff with views over tables in 7.0.2
Date
Msg-id 5703.967921918@sss.pgh.pa.us
Whole thread Raw
In response to Re: Really bad/weird stuff with views over tables in 7.0.2  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Isn't non-TEST_AND_SET code long dead?
Next
From: The Hermit Hacker
Date:
Subject: Re: Isn't non-TEST_AND_SET code long dead?