Re: pg_views view doesn't work

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" <jim@spectrumtelecorp.com> 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
>
>