The following bug has been logged online: Bug reference: 4907 Logged by: Michael Tenenbaum Email address: mich...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs