Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15068: PostgreSQL doesn't support queries that involvecolumns from multiple databases - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #15068: PostgreSQL doesn't support queries that involvecolumns from multiple databases
Date
Msg-id CAKFQuwaiLXw+emJ8mg1nSsugu048QXEp+3U6uNDp1t_Vnu0BTw@mail.gmail.com
Whole thread Raw
In response to BUG #15068: PostgreSQL doesn't support queries that involve columnsfrom multiple databases  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: Missed pgq_coop and pgq_ext in actual pgdg repository
Next
From: PG Bug reporting form
Date:
Subject: BUG #15069: group by after regexp_replace