Re: pg_views view doesn't work - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_views view doesn't work
Date
Msg-id 22682.1003268029@sss.pgh.pa.us
Whole thread Raw
In response to pg_views view doesn't work  ("Jim Buttafuoco" <jim@spectrumtelecorp.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: patrick keshishian
Date:
Subject: Re:
Next
From: "Dave Cramer"
Date:
Subject: Re: JDBC - Related Question.