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
