Re: [BUGS] FW: Noticed a Bug with stored procedures

2010-03-22 Thread Korry Douglas
Please ignore my previous mail, there were few spelling mistakes. Now you can go through below mail and respond to it. When I send update query command from front end then PostGreSql is responding with number of rows affected. But when I send same update query which is embedded in stored pr

Re: [BUGS] 9.0_alpha4 Planner Bug

2010-03-22 Thread Tom Lane
Oleg K writes: > There is a regression, in some query that was working fine in Postgre > 8.4.3 and became broken after upgrade Fixed, thanks for the report! If you need the patch right away see here: http://archives.postgresql.org/message-id/20100322135716.4a93e754...@cvs.postgresql.org

[BUGS] FW: Noticed a Bug with stored procedures

2010-03-22 Thread Gudala, Sridhar (GE EntSol, Intelligent Platforms)
Hi, Please ignore my previous mail, there were few spelling mistakes. Now you can go through below mail and respond to it. When I send update query command from front end then PostGreSql is responding with number of rows affected. But when I send same update query which is embedded in stored pro

[BUGS] Noticed a Bug with stored procedures

2010-03-22 Thread Gudala, Sridhar (GE EntSol, Intelligent Platforms)
Hi, I have a question in PostGreSQL, please go through below mail: When I send update query command from front end then PostGreSql is responding with number of rows affected. But when I send same update query which is embedded in stored procedure (as listed below) then PostGreSql doesn't respon