>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() as $$ declare a int; begin a = 1; end; $$ language plpgsql; CREATE PROCEDURE postgres=# create table p ( a int ); CREATE TABLE postgres=# alter table p add constraint c check ( a > 1 ); ALTER TABLE postgres=# create table c ( a int ); CREATE TABLE >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. +1 Regards Daniel
