Problem creating ROWTYPE variable in plpgsql. - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Problem creating ROWTYPE variable in plpgsql.
Date
Msg-id 200311081452.44762.mallah@trade-india.com
Whole thread Raw
Responses Re: Problem creating ROWTYPE variable in plpgsql.
List pgsql-general
Hi,


profile_row profile_master%ROWTYPE;
in a plpgsql function

gives the error below

tradein_clients=# SELECT general.create_accounts();
WARNING:  plpgsql: ERROR during compile of create_accounts near line 8
ERROR:  cache lookup for type 0 of profile_master.........pg.dropped.2........ failed

profile_master have had deletions of its column in past.
if i replace profile_master with another table in which no columns
were dropped there is no problem.

Has this been fixed in the upcoming version of postgresql?


Regds
Mallah.


pgsql-general by date:

Previous
From: "Edwin Quijada"
Date:
Subject: Re: Recovery Data Cant Be!!!
Next
From: Frank van Vugt
Date:
Subject: pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'