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
Дерево обсуждения
On Thu, Feb 15, 2018 at 12:16 AM, PG Bug reporting form <noreply@postgresql.org> wrote:
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 schema​s you might be able to make use of postgres_fdw

https://www.postgresql.org/docs/10/static/postgres-fdw.html

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 по дате отправления:

Предыдущее
От: Sergei Kornilov
Дата:
Сообщение: Re: Missed pgq_coop and pgq_ext in actual pgdg repository
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15069: group by after regexp_replace