Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group