Re: BUG #4907: stored procedures and changed tables - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4907: stored procedures and changed tables
Date
Msg-id 20090708193431.GL5053@alvh.no-ip.org
Whole thread Raw
In response to BUG #4907: stored procedures and changed tables  ("Michael Tenenbaum" <michael@strategic-techs.com>)
Responses Re: BUG #4907: stored procedures and changed tables  (Sergey Burladyan <eshkinkot@gmail.com>)
List 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 by date:

Previous
From: Joe Uhl
Date:
Subject: Re: Nonexistent pid in pg_locks
Next
From: Tom Lane
Date:
Subject: Re: Nonexistent pid in pg_locks