| 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
| 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? |