From: | Ben Morgan <neembi(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | psql \d command hides objects from "lower" schemas |
Date: | 2013-01-23 13:21:33 |
Message-ID: | CA+pT-SXsWU1j8oyBJBb3TCmL6bMFUop=Or5nuPKFgz=9-ysvCA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
*Version and Operating System:*
PostgreSQL 9.2.2 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.7.2, 32-bit
PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 32-bit
*Description of Bug:*
I attached a file *input.sql* which contains a few commands necessary for
bug report. In summary:
create schema front, back;
set search_path to front,back,public;
create table back.some_table (...);
create view front.some_table ...;
create table {public,back,front}.another (...);
\d
Given this, when using the psql command \d, I expect to see all the tables,
and the view as well as the table. But instead the objects in the
front-most schema mask the other objects.
I'm submitting this as a bug, because it seems to be one. If this behavior
is intended, please forgive me! (And if it is intended, is there flag to
make objects in higher schemas *not* mask other objects?)
*Steps to reproduce bug:*
$ createdb -U postgres -O benmorgan bugreport
$ psql bugreport < bugreport-input.sql
$ psql bugreport
psql (9.2.2)
Type "help" for help.
bugreport=>\d
List of relations
Schema | Name | Type | Owner
--------+-------------------+----------+-----------
back | some_table_id_seq | sequence | benmorgan
front | another | table | benmorgan
front | another_id_seq | sequence | benmorgan
front | some_table | view | benmorgan
(4 rows)
Thanks!
-Ben
Attachment | Content-Type | Size |
---|---|---|
bugreport-input.sql | application/octet-stream | 397 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-01-23 13:41:50 | Re: BUG #7821: constant disconnection with external network |
Previous Message | Pavan Deolasee | 2013-01-23 06:27:39 | Re: BUG #7824: documentation bug: Extract DOW |