Re: [GENERAL] pg_views view doesn't work

2001-10-17 Thread Jim Buttafuoco
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 hav

Re: [GENERAL] pg_views view doesn't work

2001-10-16 Thread Tom Lane
"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

[GENERAL] pg_views view doesn't work

2001-10-16 Thread Jim Buttafuoco
Hi all, I am having a problem with the "pg_views" view. It seems that the internal function pg_get_viewdef() is the problem. See below. This problem is preventing me from dumping the database (either as 1 export or 1 table at a time). I have recreated the database, but the problem seems to