possible psql \d bug in 8.3 beta2

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: possible psql \d bug in 8.3 beta2
Date: 2007-12-24 03:16:35
Message-ID: 852299.6370.qm@web31812.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is seems that \d is missing the following entry
when I set search_path to display two schemas:
List of relations
Schema | Name | Type | Owner
---------+-------------+-------+----------
project | managers | table | teaminst

instrumentation=> select version();
version
--------------------------------------------------------
PostgreSQL 8.3beta2, compiled by Visual C++ build 1400
(1 row)

instrumentation=> set search_path to project;
SET
instrumentation=> \d
List of relations
Schema | Name | Type | Owner
---------+-------------+-------+----------
project | managers | table | teaminst
project | project_tls | table | teaminst
project | projects | table | teaminst
(3 rows)

instrumentation=> set search_path to history;
SET
instrumentation=> \d
List of relations
Schema | Name | Type | Owner
---------+----------+-------+----------
history | managers | table | teaminst
(1 row)

instrumentation=> set search_path to history, project;
SET
instrumentation=> \d
List of relations
Schema | Name | Type | Owner
---------+-------------+-------+----------
history | managers | table | teaminst <--where is project.managers
project | project_tls | table | teaminst
project | projects | table | teaminst
(3 rows)

instrumentation=>

Regards,
Richard Broersma Jr.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-12-24 03:28:29 Re: possible psql \d bug in 8.3 beta2
Previous Message Richard Broersma Jr 2007-12-23 23:35:59 Re: Constraint Trigger's referenced_table