| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Fabien COELHO <fabien(dot)coelho(at)ensmp(dot)fr> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Further thoughts about warning for costly FK checks |
| Date: | 2004-03-15 14:39:37 |
| Message-ID: | 22751.1079361577@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Fabien COELHO <fabien(dot)coelho(at)ensmp(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-15 15:00:54 | Re: Custom format for pg_dumpall |
| Previous Message | Bruce Momjian | 2004-03-15 14:03:12 | Re: Custom format for pg_dumpall |