| 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: | Whole Thread | Raw Message | 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 |