Re: [BUGS] BUG #6360: with hold cursor, cause function executed twice and wrong results

2011-12-27 Thread wcting163
At 2011-12-28 01:47:20,"Tom Lane" t...@sss.pgh.pa.us> wrote: Yup. I don't particularly see this as a bug. If you were to manually >rewind and rescan the cursor (ie, MOVE BACKWARD ALL and re-fetch), >the function would be executed multiple times too. If you don't want >that to happen, the best wa

[BUGS] with hold cursor, cause function execute twice and wrong result

2011-12-27 Thread wcting163
postgres=# select version(); version --- PostgreSQL 9.0alpha5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4

[BUGS] BUG #6360: with hold cursor, cause function executed twice and wrong results

2011-12-27 Thread wcting163
The following bug has been logged on the website: Bug reference: 6360 Logged by: ctwang Email address: wcting...@163.com PostgreSQL version: 9.0.5 Operating system: linux 2.6.18-128.7AXS3 Description: create table test_execute(id int,name varchar(40)); insert into te