Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-27 Thread Bruce Momjian
OK, change made and applied. --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I think v,s,t are all relkinds to exclude here. > > > Is 't' for toast tables? If so, we should allow 't

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-27 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I think v,s,t are all relkinds to exclude here. > Is 't' for toast tables? If so, we should allow 't', no? I wasn't sure > about 's'? Wups, you are right --- I was thinking 't' meant 'composite type'. The only 's' in the system is

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-27 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > ! "where reltype not in > > ('v','c') and " > > Surely you meant relkind. Also, there is no 'c' relkind; perhaps you > meant 's'? I think v,s,t are all relkinds to exclude here. Ye

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-27 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > ! "where reltype not in > ('v','c') and " Surely you meant relkind. Also, there is no 'c' relkind; perhaps you meant 's'? I think v,s,t are all relkinds to exclude here. rega

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-26 Thread Bruce Momjian
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

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-23 Thread Bruce Momjian
Sorry, patch removed from patch queue. I will rework the patch to skip views completely, OK? --- Kenji Sugita wrote: > This small patch eliminates relations in information_schema from oid2name > listing. > Index: oid2name.

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-23 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Kenji Sugita wrote: > This small patch el

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-21 Thread Tom Lane
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, wha

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-21 Thread Peter Eisentraut
Kenji Sugita writes: > This small patch eliminates relations in information_schema from oid2name > listing. Why would one want to do that? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-20 Thread Kenji Sugita
From: Tom Lane <[EMAIL PROTECTED]> Subject: Re: [PATCHES] Eliminate information_schema from oid2name listing Date: Mon, 21 Jul 2003 00:32:46 -0400 ;;; Kenji Sugita <[EMAIL PROTECTED]> writes: ;;; > This small patch eliminates relations in information_schema from oid2nam

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-20 Thread Tom Lane
Kenji Sugita <[EMAIL PROTECTED]> writes: > This small patch eliminates relations in information_schema from oid2name > listing. Seems like it'd be a good idea to eliminate views and composite types as well. regards, tom lane ---(end of broadcast)--

[PATCHES] Eliminate information_schema from oid2name listing

2003-07-20 Thread Kenji Sugita
This small patch eliminates relations in information_schema from oid2name listing. Index: oid2name.c === RCS file: /projects/cvsroot/pgsql-server/contrib/oid2name/oid2name.c,v retrieving revision 1.18 diff -u -r1.18 oid2name.c --- oid2