Fabien COELHO <fabien.coelho@ensmp.fr> writes:
>> Maybe there should be a separate "pg_advisor" tool that you can run against a
>> database and which looks for "oddities". Something pluggable so people can
>> add tests simply.
> Or maybe some new "ADVICE" or "ODDITY" level next to "DEBUG NOTICE WARNING
> ERROR PANIC...", that would be hidden by default and triggered by an
> option?
But that doesn't really solve the problem, which is that there are
conditions that it's difficult to test for on-the-fly while a schema
is being constructed. A pg_advisor tool would look at the completed
schema and would not have that problem.
regards, tom lane