Re: [GENERAL] change table to view problem

2005-02-03 Thread Richard Huxton
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 swit

Re: [GENERAL] change table to view problem

2005-02-02 Thread Sim Zacks
Actually it's only the views that have this problem. The funcitons have kept the original table name which is now the name of the view. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.