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. regards,

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. Yes, sorry,

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', no? I

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,

[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 ---

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

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 oid2name ;;; listing. ;;; ;;; Seems