| From: | <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | Stephan Szabo <sszabo(at)io(dot)com> |
| Cc: | janwieck(at)yahoo(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: VIEW problem |
| Date: | 2000-10-10 03:29:56 |
| Message-ID: | Pine.LNX.4.10.10010092328230.13021-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 6 Oct 2000, Stephan Szabo wrote:
> About view rules:
> Of course, you shouldn't actually be
> able to get into the situation with
> a view rule, since dropping the table
> the view points to should drop the view
> (or refuse to drop the table) it appears
> from looking at drop table in the spec.
If you specify that the view have this behaviour, yes... but even Oracle
has gotten me on several occasions for this same thing, dropping a table,
then rebuilding, then fscking up the view.
Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Beam me up, Scotty! It ate my phaser!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-10-10 03:32:53 | Re: Help needed : temp tables. |
| Previous Message | Neil Conway | 2000-10-10 03:25:31 | Re: Postgres 7.1 and the 8k tuple / row limit |