Bug reference: 18892 Logged by: Gavin Email address: gchen@s2now.com PostgreSQL version: 16.8 Operating system: Red Hat Enterprise Linux release 9.5 Description:
However, as demonstrated in my test demo, when the view already exists, running CREATE OR REPLACE VIEW does not check whether the table exists.
Because of the whole shared namespace setup it would be impossible for a table of that name to exist when executing the "or replace" branch since the view being replaced occupies that name within the namespace. Any check for an actual table would return false. And "or replace" only happens if a view of that name exists.
Kirill's answer is correct; though it is a bit annoying that "create view" cannot detect the infinite recursion inherent in its body.
