Re: Re: VIEW problem - Mailing list pgsql-general

From
Subject Re: Re: VIEW problem
Date
Msg-id Pine.LNX.4.10.10010092328230.13021-100000@chapelperilous.net
Whole thread Raw
In response to Re: VIEW problem  (Stephan Szabo <sszabo@io.com>)
List 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!


pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Postgres 7.1 and the 8k tuple / row limit
Next
From: Tom Lane
Date:
Subject: Re: Help needed : temp tables.