Tom Thanks for your reply.
I dropped ALL of my views and recreated from a script. This seems to have worked. I am running my nightly jobs now to see if some how they are causing the views to break. I will report back later. Jim > "Jim Buttafuoco" <[EMAIL PROTECTED]> writes: > > I am having a problem with the "pg_views" view. It seems that the > > internal function pg_get_viewdef() is the problem. See below. > > It looks to me like you've got some one view that refers to a > no-longer-existent function. To figure out which it is, try > "select * from pg_views limit N" for various N until you know > where the failing row is, then extract just the viewname of that > row. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
