pg_views view doesn't work

From: "Jim Buttafuoco" <jim(at)spectrumtelecorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_views view doesn't work
Date: 2001-10-16 12:28:39
Message-ID: 200110161228.IAA23427@server1.spectrumtelecorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 have come back again last night. If I create a new
database now the problem doesn't happen.

Thanks
Jim

TEST=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

TEST=# select * from pg_views;
ERROR: cache lookup for proc 189295778 failed
TEST=#

TEST=# \d pg_views
View "pg_views"
Attribute | Type | Modifier
------------+------+----------
viewname | name |
viewowner | name |
definition | text |
View definition: SELECT c.relname AS viewname,
pg_get_userbyid(c.relowner) AS viewowner, pg_get_viewdef(c.relname) AS
definition FROM pg_class c WHERE (c.relkind = 'v'::"char");

TEST=# select pg_get_viewdef(c.relname) from pg_class c;
ERROR: cache lookup for proc 189295778 failed
TEST=#

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Klawitter 2001-10-16 12:56:39 Re:
Previous Message David Cana 2001-10-16 12:28:13 Queries and views