Namespace/Table Visibility Behavior Issues
От | D. Hageman |
---|---|
Тема | Namespace/Table Visibility Behavior Issues |
Дата | |
Msg-id | Pine.LNX.4.50.0301181637350.29502-100000@moko.dracken.com обсуждение исходный текст |
Ответ на | constraint defaults still print (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: Namespace/Table Visibility Behavior Issues
|
Список | pgsql-hackers |
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> || \\========================================================//
В списке pgsql-hackers по дате отправления: