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)
