Regarding the NOTICE
CREATE TABLE will create implicit triggers for foreign-key checks
Does anyone care?
The other "helpful" notices about sequences for serial columns and indexes
for unique constraints have some merit, because they inform the user
objects that the user might be interested in are going to be created as a
side effect. But there's nothing that a user can reasonably do with an
implicit trigger for a foreign-key check. ISTM that this notice is about
as interesting as the information that CREATE VIEW will create an implicit
rule.
--
Peter Eisentraut peter_e(at)gmx(dot)net