pg_views view doesn't work
От | Jim Buttafuoco |
---|---|
Тема | pg_views view doesn't work |
Дата | |
Msg-id | 200110161228.IAA23427@server1.spectrumtelecorp.com обсуждение исходный текст |
Ответы |
Re: pg_views view doesn't work
|
Список | 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=#
В списке pgsql-general по дате отправления: