Re: BUG #4907: stored procedures and changed tables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Michael Tenenbaum <michael(at)strategic-techs(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4907: stored procedures and changed tables
Date: 2009-07-08 19:34:31
Message-ID: 20090708193431.GL5053@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-07-08 19:42:07 Re: Nonexistent pid in pg_locks
Previous Message Joe Uhl 2009-07-08 19:08:24 Re: Nonexistent pid in pg_locks