Patch attached and applied. ---------------------------------------------------------------------------
Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Kenji Sugita writes: > >> This small patch eliminates relations in information_schema from oid2name > >> listing. > > > Why would one want to do that? > > AFAICS the point of oid2name is to provide a mapping between disk file > names and table names. As such, what it *ought* to be doing is > suppressing views, since those don't have disk files --- they are only > cluttering the listing with irrelevant data. If we put that in, there'd > be no need to special-case information_schema. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: contrib/oid2name/oid2name.c =================================================================== RCS file: /cvsroot/pgsql-server/contrib/oid2name/oid2name.c,v retrieving revision 1.18 diff -c -c -r1.18 oid2name.c *** contrib/oid2name/oid2name.c 14 May 2003 03:25:56 -0000 1.18 --- contrib/oid2name/oid2name.c 27 Jul 2003 04:42:11 -0000 *************** *** 355,361 **** if (systables == 1) snprintf(todo, 1024, "select relfilenode,relname from pg_class order by relname"); else ! snprintf(todo, 1024, "select relfilenode,relname from pg_class where relname not like 'pg_%%' order by relname"); sql_exec(conn, todo, 0); } --- 355,363 ---- if (systables == 1) snprintf(todo, 1024, "select relfilenode,relname from pg_class order by relname"); else ! snprintf(todo, 1024, "select relfilenode,relname from pg_class " ! "where reltype not in ('v','c') and " ! "relname not like 'pg_%%' order by relname"); sql_exec(conn, todo, 0); }
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster