pg_tables and schemas
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
"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
"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