Re: Really bad/weird stuff with views over tables in 7.0.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alfred Perlstein <bright(at)wintelcom(dot)net>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Really bad/weird stuff with views over tables in 7.0.2
Date: 2000-09-02 19:11:58
Message-ID: 5703.967921918@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alfred Perlstein <bright(at)wintelcom(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-09-02 19:21:50 Re: Isn't non-TEST_AND_SET code long dead?
Previous Message Tom Lane 2000-09-02 19:06:14 Isn't non-TEST_AND_SET code long dead?