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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org