psql \d command hides objects from "lower" schemas

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

Responses

Browse pgsql-bugs by date

  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