The following bug has been logged online:
Bug reference: 4907
Logged by: Michael Tenenbaum
Email address: michael@strategic-techs.com
PostgreSQL version: 8.2.11
Operating system: Gentoo
Description: stored procedures and changed tables
Details:
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.
Any chance a future release can check for stored procedures that return a
set of records of a changed table?
Thanks.