Thread: pg_tables and schemas

pg_tables and schemas

From
"Christopher Kings-Lynne"
Date:
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        | ftest
 | chriskl    | f          | f        | f
 
(2 rows)

Chris





Re: pg_tables and schemas

From
Tom Lane
Date:
"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




Re: pg_tables and schemas

From
"Christopher Kings-Lynne"
Date:
> "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