Re: BUG #15068: PostgreSQL doesn't support queries that involve columns from multiple databases

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: mahendra(at)datam(dot)co(dot)uk, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15068: PostgreSQL doesn't support queries that involve columns from multiple databases
Date: 2018-02-15 14:48:47
Message-ID: CAKFQuwaiLXw+emJ8mg1nSsugu048QXEp+3U6uNDp1t_Vnu0BTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Feb 15, 2018 at 12:16 AM, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 15068
> Logged by: Mahendra Sri dayarathna
> Email address: mahendra(at)datam(dot)co(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-02-15 15:14:49 BUG #15069: group by after regexp_replace
Previous Message Sergei Kornilov 2018-02-15 11:23:15 Re: Missed pgq_coop and pgq_ext in actual pgdg repository