Problem creating ROWTYPE variable in plpgsql.

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Problem creating ROWTYPE variable in plpgsql.
Дата
Msg-id 200311081452.44762.mallah@trade-india.com
обсуждение исходный текст
Ответы Re: Problem creating ROWTYPE variable in plpgsql.
Список 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 по дате отправления:

Предыдущее
От: "Edwin Quijada"
Дата:
Сообщение: Re: Recovery Data Cant Be!!!
Следующее
От: Frank van Vugt
Дата:
Сообщение: pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'