Tom Lane wrote: > But having said that, I do not foresee being able to replace direct > pg_catalog access with INFORMATION_SCHEMA views anytime soon. There > are too many clients out there that are used to doing it that way. > > Moreover, pg_dump will never be able to work off INFORMATION_SCHEMA, > because it needs to get at Postgres-specific information that will > not be available from a spec-compliant set of views. I'm fairly > dubious about converting psql, even. > > Rod's welcome to work on developing a set of spec-compliant > INFORMATION_SCHEMA views ... and maybe he can even turn off public > read access to pg_catalog in his own installation ... but he should > not expect us to accept a patch that makes that the default anytime > in the foreseeable future.
Yes, it would be nice to have spec-compliant stuff. However, things like psql really get into those catalogs and grab detailed information that is probably not covered the the spec. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
