Re: Invalidating dependent views and functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Invalidating dependent views and functions
Date
Msg-id 24293.1272638299@sss.pgh.pa.us
Whole thread Raw
In response to Invalidating dependent views and functions  (Scott Bailey <artacus@comcast.net>)
Responses Re: Invalidating dependent views and functions  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Scott Bailey <artacus@comcast.net> writes:
> Proposal: Add an invalid flag to pg_class. Invalid objects would be 
> ignored when doing dependency checks for DDL statements. And an 
> exception would be thrown when an invalid object is called.

IMO, the way Oracle does this pretty much sucks, and shouldn't be
emulated.  If they know how to recompile the view, why don't they
just do it?  What you describe is about as user-unfriendly as it
gets.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: missing file in git repo
Next
From: Tom Lane
Date:
Subject: Re: pg_migrator to /contrib in a later 9.0 beta