Обсуждение: BUG #8569: with recursive work incorrectly with function
The following bug has been logged on the website: Bug reference: 8569 Logged by: Jing Fan Email address: fanjing09@gmail.com PostgreSQL version: 9.1.9 Operating system: ubuntu 13.04 Description: with recursive table as( seed statement union all recursive statement ) in the recursive statement, I use functions, that is select * from functionname(). I tried the function seperately and it can return correct result. However, the query just stopped recursion when new tuples are still generated from recursive statement.(actually the recursive part is just executed once). I wonder whether it is a bug?
fanjing09 wrote > The following bug has been logged on the website: > > Bug reference: 8569 > Logged by: Jing Fan > Email address: > fanjing09@ > PostgreSQL version: 9.1.9 > Operating system: ubuntu 13.04 > Description: > > with recursive table as( > seed statement > union all > recursive statement > ) > in the recursive statement, I use functions, that is select * from > functionname(). I tried the function seperately and it can return correct > result. However, the query just stopped recursion when new tuples are > still > generated from recursive statement.(actually the recursive part is just > executed once). I wonder whether it is a bug? We need to see the actual query you are running AND the "CREATE FUNCTION" statement that you are using in the recursive part of the query. It is likely not a bug but rather some combination of function volatility and/or an incorrect query that is causing the problem. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8569-with-recursive-work-incorrectly-with-function-tp5776396p5776409.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.