I am trying to run a query which has around 1000 iteration with the help of "WITH RECURSIVE" clause. But when I try to run it, it gives an error "A recursive CTE has reached the maximum number of iterations: 100." Tried a lot of things but all in vain.
When I tried to make the loop smaller than 100 its running properly. Any suggestions on how to overcome this problem ?
LinkedIn
Twitter
