[BUGS] BUG #4907: stored procedures and changed tables
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
[BUGS] BUG #5271: pg_dump: schema with OID 22519 does not exist
The following bug has been logged online: Bug reference: 5271 Logged by: Michael Tenenbaum Email address: mich...@strategic-techs.com PostgreSQL version: 8.3.9 Operating system: Gentoo Linux Description:pg_dump: schema with OID 22519 does not exist Details: According to the posts I picked up from a Google search, this is a bug that never seems to get fixed. I followed Tom's advice and deleted entries in pg_type and pg_class and pg_dump is working ok. The object was a table in a development system with only a few entries. hardly anything was written to the table in the past few weeks, but the daily pg_dump was working fine until this evening. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
