Re: BUG #15068: PostgreSQL doesn't support queries that involvecolumns from multiple databases
| От | David G. Johnston |
|---|---|
| Тема | Re: BUG #15068: PostgreSQL doesn't support queries that involvecolumns from multiple databases |
| Дата | |
| Msg-id | CAKFQuwaiLXw+emJ8mg1nSsugu048QXEp+3U6uNDp1t_Vnu0BTw@mail.gmail.com обсуждение исходный текст |
| Ответ на | BUG #15068: PostgreSQL doesn't support queries that involve columnsfrom multiple databases (PG Bug reporting form <noreply@postgresql.org>) |
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15068
Logged by: Mahendra Sri dayarathna
Email address: mahendra@datam.co.uk
PostgreSQL version: 9.4.0
Operating system: Windows
Description:
I try to create view using involve columns from multiple databases.
then i have issue postgresql cross database reference are not implemented.
how to resolve that issue
This is a question better suited to the -general list as it is not a bug report.
If you are indeed using 9.4.0 you need to upgrade to a supported release - which is 9.4.16 at the time of this report.
In addition to Michael's suggestion of using schemas you might be able to make use of postgres_fdw
Work on that area has been ongoing recently and if you go for that approach you should probably strongly consider bumping up to version 9.6 or 10. 9.4 has a little over a year of support-life left in it anyway.
David J.
В списке pgsql-bugs по дате отправления: