Package: postgresql-client
Version: 7.4.7-6
Severity: normal
When the search_path is set to include more than one schema, and if two
or more templates have the same relation, \d will only return the first
instance of the relation. For example,
template1=# create database test;
CREATE DATABASE
template1=# \c test
You are now connected to database "test".
test=# CREATE SCHEMA ts;
CREATE SCHEMA
test=# SET search_path=ts,public;
SET
test=# create table ts.test();
CREATE TABLE
test=# create table public.test();
CREATE TABLE
test=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+----------
ts | test | table | postgres
(1 row)
test=# set search_path=public;
SET
test=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+----------
public | test | table | postgres
(1 row)
It should list all relations on the search_path which includes public.ts
and test.ts
- Adam
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.11-1-k7
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)
Versions of packages postgresql-client depends on:
ii debconf [debconf-2.0] 1.4.49 Debian configuration management sy
ii debianutils 2.13.2 Miscellaneous utilities specific t
ii libc6 2.3.2.ds1-21 GNU C Library: Shared libraries an
ii libkrb53 1.3.6-3 MIT Kerberos runtime libraries
ii libpam0g 0.76-22 Pluggable Authentication Modules l
ii libpq3 7.4.7-6 PostgreSQL C client library
ii libreadline4 4.3-15 GNU readline and history libraries
ii libssl0.9.7 0.9.7e-3 SSL shared libraries
ii zlib1g 1:1.2.2-4 compression library - runtime
-- debconf information:
postgresql-client/missing-postgresql.env: true
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
