Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-07-08 19:42:07
Subject: Re: Nonexistent pid in pg_locks
Previous:From: Joe UhlDate: 2009-07-08 19:08:24
Subject: Re: Nonexistent pid in pg_locks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group