Re: [BUGS] BUG #4907: stored procedures and changed tables

2009-07-09 Thread Pavel Stehule
Hello this is known bug - you have to drop modified table and create it again. I believe so this should be fixed early - in this summer. regards Pavel Stehule 2009/7/10 Sergey Burladyan : > Alvaro Herrera writes: > >> Michael Tenenbaum wrote: >> >> > If I have a stored procedure that returns a

Re: [BUGS] BUG #4907: stored procedures and changed tables

2009-07-09 Thread Sergey Burladyan
Sergey Burladyan writes: > Alvaro Herrera writes: > > > 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. >

Re: [BUGS] BUG #4907: stored procedures and changed tables

2009-07-09 Thread Sergey Burladyan
Alvaro Herrera writes: > 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

Re: [BUGS] BUG #4907: stored procedures and changed tables

2009-07-08 Thread Alvaro Herrera
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 > t

[BUGS] BUG #4907: stored procedures and changed tables

2009-07-07 Thread Michael Tenenbaum
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 pro