I didn't see this make it to the list. I thought I would try again.
--
//========================================================\\
|| D. Hageman <dhageman@dracken.com> ||
\\========================================================//
---------- Forwarded message ----------
Date: Sat, 18 Jan 2003 16:51:12 -0600 (CST)
From: D. Hageman <dhageman@dracken.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Namespace/Table Visibility Behavior Issues
Assume a database with a couple of namespaces. Give two of these
namespaces the names test_1 and test_2. Under these namespaces create a
couple of tables with the names: example, example_2, example_3.
set search_path to test_1, test_2;
In the psql client, using a standard \d you will only see the namespace
test_1 listed and the tables underneath that. test_2 will not be visible
due to the fact they fail the pg_table_is_visible() check.
I am not sure that is wise to do the pg_table_is_visible check on those
commands. In my humble opinion, those commands are for understanding the
layout/structure/nature of the database. If you can't see all your
namespaces that you set in your search_path then it could distort ones
understanding of the database.
--
//========================================================\\
|| D. Hageman <dhageman@dracken.com> ||
\\========================================================//