Hi, Imre , What happens when the recursive query encounters a node of divergence?
Which way will it walk down a network? Regards, David On Sunday, 8 May 2022, Imre Samu <[email protected]> wrote: > Hi David, > > There is a loop of recursive query. It runs at a point where it stops. > >Can anyone provide pointers how to solve this problem or work around? > > Please share "this" recursive query; > > My guess: Probably you have a "forever/endless loop" in your data; *so > you have to LIMIT the recursive part ;* > > related links : > 1.) with limiting "depth" ( where depth < 1000 ) > "Prevent infinite loop in recursive query in Postgresql" > https://stackoverflow.com/questions/51025607/prevent- > infinite-loop-in-recursive-query-in-postgresql > 2.) with LIMITING clause > https://www.cybertec-postgresql.com/en/recursive-queries-postgresql/ > *"This example also demonstrates how an endless loop can be avoided with a > LIMIT clause on the parent query."* > > Regards, > Imre > > Shaozhong SHI <[email protected]> ezt írta (időpont: 2022. máj. 7., > Szo, 15:23): > >> There is a loop of recursive query. It runs at a point where it stops. >> >> This error turned up.- ERROR: invalid memory alloc request size >> 1073741824 >> >> Can anyone provide pointers how to solve this problem or work around? >> >> Regards, >> >> David >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
