pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer

2024-07-14 Thread Tom Lane
Avoid unhelpful internal error for incorrect recursive-WITH queries. checkWellFormedRecursion would issue "missing recursive reference" if a WITH RECURSIVE query contained a single self-reference but that self-reference was inside a top-level WITH, ORDER BY, LIMIT, etc, rather than inside the seco

pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer

2024-07-14 Thread Tom Lane
Avoid unhelpful internal error for incorrect recursive-WITH queries. checkWellFormedRecursion would issue "missing recursive reference" if a WITH RECURSIVE query contained a single self-reference but that self-reference was inside a top-level WITH, ORDER BY, LIMIT, etc, rather than inside the seco

pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer

2024-07-14 Thread Tom Lane
Avoid unhelpful internal error for incorrect recursive-WITH queries. checkWellFormedRecursion would issue "missing recursive reference" if a WITH RECURSIVE query contained a single self-reference but that self-reference was inside a top-level WITH, ORDER BY, LIMIT, etc, rather than inside the seco

pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer

2024-07-14 Thread Tom Lane
Avoid unhelpful internal error for incorrect recursive-WITH queries. checkWellFormedRecursion would issue "missing recursive reference" if a WITH RECURSIVE query contained a single self-reference but that self-reference was inside a top-level WITH, ORDER BY, LIMIT, etc, rather than inside the seco

pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer

2024-07-14 Thread Tom Lane
Avoid unhelpful internal error for incorrect recursive-WITH queries. checkWellFormedRecursion would issue "missing recursive reference" if a WITH RECURSIVE query contained a single self-reference but that self-reference was inside a top-level WITH, ORDER BY, LIMIT, etc, rather than inside the seco

pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer

2024-07-14 Thread Tom Lane
Avoid unhelpful internal error for incorrect recursive-WITH queries. checkWellFormedRecursion would issue "missing recursive reference" if a WITH RECURSIVE query contained a single self-reference but that self-reference was inside a top-level WITH, ORDER BY, LIMIT, etc, rather than inside the seco

pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer

2024-07-14 Thread Tom Lane
Avoid unhelpful internal error for incorrect recursive-WITH queries. checkWellFormedRecursion would issue "missing recursive reference" if a WITH RECURSIVE query contained a single self-reference but that self-reference was inside a top-level WITH, ORDER BY, LIMIT, etc, rather than inside the seco