Re: BUG #4907: stored procedures and changed tables

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #4907: stored procedures and changed tables
Дата
Msg-id 20090708193431.GL5053@alvh.no-ip.org
обсуждение исходный текст
Ответ на BUG #4907: stored procedures and changed tables  ("Michael Tenenbaum" <michael@strategic-techs.com>)
Ответы Re: BUG #4907: stored procedures and changed tables  (Sergey Burladyan <eshkinkot@gmail.com>)
Список pgsql-bugs
Michael Tenenbaum wrote:

> If I have a stored procedure that returns a set of records of a table, I get
> an error message that the procedure's record is the wrong type after I
> change some columns in the table.
>
> Deleting the procedure then rewriting the procedure does not help.  The only
> thing that works is deleting both the stored procedure and the table and
> starting over again.

Does it work if you disconnect and connect again?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Joe Uhl
Дата:
Сообщение: Re: Nonexistent pid in pg_locks
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Nonexistent pid in pg_locks