Tom,

Does the pg_tables view need to be fixed now that we have schemas?

Yep:

test2=# create schema a;
CREATE SCHEMA
test2=# create schema b;
CREATE SCHEMA
test2=# create table a.test (a int4);
CREATE TABLE
test2=# create table b.test (b int4);
CREATE TABLE
test2=# select * from pg_tables where tablename not like 'pg_%';
 tablename | tableowner | hasindexes | hasrules | hastriggers
-----------+------------+------------+----------+-------------
 test      | chriskl    | f          | f        | f
 test      | chriskl    | f          | f        | f
(2 rows)

Chris




Tue, 9 Jul 2002 17:26:03 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
pg_tables and schemas
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Does the pg_tables view need to be fixed now that we have schemas?

Yeah, many of the system views need work.  I haven't stopped to think
about it yet.  If anyone else wants to come up with a proposal,
go for it...

			regards, tom lane



Tue, 09 Jul 2002 10:42:23 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_tables and schemas 
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > Does the pg_tables view need to be fixed now that we have schemas?
>
> Yeah, many of the system views need work.  I haven't stopped to think
> about it yet.  If anyone else wants to come up with a proposal,
> go for it...

Well, just so long as it doesn't get forgotten before 7.3 is released!  I
think it would be enough to just let the namespaceid column get into the
views?

I just noticed it when I started adding schema support to WebDB (phpPgAdmin
next gen)

Chris


Wed, 10 Jul 2002 09:51:52 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: pg_tables and schemas 