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 schemas 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.
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 |