David Fetter <david@fetter.org> writes:
> What's the effect, if any, on CTEs that depend on each other
> explicitly?
An error. That would require mutual recursion, which we don't
support for the SELECT case let alone data-modifying statements.
regards, tom lane