| From: | Patrice Lefebvre <plefebvre(at)ctecworld(dot)com> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Creating a schema opens the wrong database |
| Date: | 2012-09-27 11:47:58 |
| Message-ID: | 50643CEE.7030604@ctecworld.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On my postgreSQL server I have a database called 'mydb' and 'mydb_test'
(and many other databases). When I open the database 'mydb_test', go to
Schemas, create a new schema (I called mine 'report') using the visual
tool and press OK, the schema is correctly created in 'mydb_test' but
pgAdmin also decides to open the database called 'mydb'. When I look at
pg_stat_activity, it is indeed showing me a connection to 'mydb', even
though prior to that action I was only connected to 'mydb_test'.
I've successfully reproduced the bug using other database names, as long
as I have two databases named similarly to anydbname and
anydbname_something.
I use pgAdmin 1.16.0 (Sep 7 2012, rev: REL-1_16_0, from binary) under
Windows XP SP3, English version but on a Canadian French OS.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Greco | 2012-09-27 13:01:09 | Foreign Servers |
| Previous Message | Colin Beckingham | 2012-09-27 06:42:12 | Error on tools - server configuration and status |