From: | totocrenn(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14535: SET search_path and list tables |
Date: | 2017-02-08 11:33:00 |
Message-ID: | 20170208113300.1411.83851@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14535
Logged by: Thomas Crenn
Email address: totocrenn(at)gmail(dot)com
PostgreSQL version: 9.6.1
Operating system: Windows
Description:
Hi,
I will explain the bug with an example :
I have 2 SCHEMAS : test and demo
Each schemas have the same TABLE : table
Then I change the search path :
SET search_path TO test, demo;
So when I list all the tables with \dt I should have 2 tables : test.table
and demo.table, but I only see test.table.
After checking, the table demo.table exist but is just not display on the
list.
I guess it's because the query apply a DISTINCT only on the table and not on
the couple (schema , table).
I don't know if it's a bug or if this choice is justified so i have decided
to report you this.
Best regards.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-02-08 15:03:33 | Re: BUG #14535: SET search_path and list tables |
Previous Message | NAVEEN CHALIMETI | 2017-02-08 06:39:06 | Re: BUG #14531: server process (PID 12714) was terminated by signal 11: Segmentation fault |