On Sat, 2021-10-30 at 11:08 +, Daniel Westermann (DWE) wrote:
> HI all,
>
> in the documentation for CREATE TABLE we have this sentence:
>
> "The name of the table must be distinct from the name of any other table,
> sequence, index, view, or foreign table in the same schema."
>
> At least
>a) Don't forget: constraint, function, procedure, trigger.
Functions don't count:
postgres=# create function f() returns int as $$ select 1; $$ language sql;
CREATE FUNCTION
postgres=# create table f ( a int );
CREATE TABLE
Procedures and constraints don't count:
postgres=# create procedure p()
