Problem creating ROWTYPE variable in plpgsql.

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem creating ROWTYPE variable in plpgsql.
Date: 2003-11-08 09:22:44
Message-ID: 200311081452.44762.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank van Vugt 2003-11-08 10:08:58 pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'
Previous Message Edwin Quijada 2003-11-08 06:04:07 Re: Recovery Data Cant Be!!!