a) Don't forget: constraint, function, procedure, trigger.
b) The hint applies to each of such objects: CREATE
[TABLE|VIEW|FUNCTION|...]. To avoid such redundancy we could extend and
clarify the definition of 'SQL object / local object / global object'
within the glossary and refer to it.
c)
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 materialized views are missing:
postgres=# create materialized view t as select 1
