Обсуждение: change table to view problem

I merged 2 tables into 1 table and created a view  for each of the tables so
as not to break existing applications. I renamed the old tables with the
_old suffix in case there was a problem so I could verify against the old
data.

The problem is that all the views and functions switched the name of the
table to the renamed table and do not use the new views I have created. Is
there a recommended way of updating all the views and functions that  use
the table to start using the view?

Thank You
Sim

Sim Zacks wrote:
> I merged 2 tables into 1 table and created a view  for each of the tables so
> as not to break existing applications. I renamed the old tables with the
> _old suffix in case there was a problem so I could verify against the old
> data.
>
> The problem is that all the views and functions switched the name of the
> table to the renamed table and do not use the new views I have created. Is
> there a recommended way of updating all the views and functions that  use
> the table to start using the view?

This is how it's supposed to work. System objects (views, foreign-keys,
some functions etc) track other objects by their OID. Otherwise changes
to table-names, or schema search-paths could wreak havoc.

If you want to attach the views to the new tables then you'll need to
recreate them.

--
   Richard Huxton
   Archonet Ltd