On Wed, May 5, 2010 at 7:31 AM, Thom Brown <thombrown@xxxxxxxxx> wrote: > On 5 May 2010 13:14, Chris Barnes <compuguruchrisbarnes@xxxxxxxxxxx> wrote: >> >> It has been some years since I worked with Oracle, doesn't Oracle >> recompile the view when the object it references changes in structure? >> Send > > What does Oracle do when you've got a view like: > > CREATE OR REPLACE VIEW test_view AS > SELECT test.test_id, test.test_value, date_is_future(test.test_date) as > upcoming > FROM test; > > Where date_is_future expects a text field, but you change the test table so > that test_date is now varchar(20)? The function no longer matches the > signature. Does it just prevent it? And what about when conditions are > provided in a WHERE clause which become invalid when the column type > changes? > If Oracle can find a function that will make the view valid it will continue to allow usage of the view; though it is still marked as needing to be rebuilt from a user perspective any calls to it will succeed if there is a possible way for the view to still be valid. If there is no possible way for any use of the view to succeed then the calls fail. -- Peter Hunsberger -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
