Fabien COELHO <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly