Thread: select * from pg_veiw; errors in 6.5 and 6.4.2

Anytime I create a view that includes a call to a C function in a library I
created, I get the following errors in pgsql:

select * from pg_views;
ERROR:  cache lookup of attribute 0 in relation 148801 failed


Select * from pg_tables;
Works

\dt works okay.

Red Hat 5.2, Intel, psql and PostgreSQL version 6.5.  This error also
appeared in version 6.4.2.

Thanks, Michael

>
> Anytime I create a view that includes a call to a C function in a library I
> created, I get the following errors in pgsql:
>
> select * from pg_views;
> ERROR:  cache lookup of attribute 0 in relation 148801 failed

    Must be in utils/adt/ruleutils.c - I'll take a look.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #