PG Bug reporting form <noreply@postgresql.org> writes:
> After upgrading from Postgres 17 to 18, one of my queries started raising an
> error:
> "unexpected outer reference in CTE query"
I agree that sounds like a bug ...
> The problematic query is:
>
https://github.com/openstreetmap-ng/openstreetmap-ng/blob/eb805d8766fb4b359b96eb6b50acc8c2a835a165/app/services/element_spatial_service.py#L82-L215
... but I am not going to spend time trying to reproduce it given
this amount of detail. There's too much missing context, like what
data you were running the query on. I could spend all day, not
see the failure, and be left no wiser than before as to whether
it's already fixed or I just didn't duplicate your context closely
enough. Please see if you can reduce the problem case to a
self-contained SQL script.
regards, tom lane
