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

From: Michael Paquier <michael(at)paquier(dot)xyz>
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 07:43:14
Message-ID: 20180215074314.GA25356@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Feb 15, 2018 at 07:16:03AM +0000, PG Bug reporting form wrote:
> 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 not supported as each backend session can only be connected to
one single database. Have you considered using different schema for
this purpose? This is an extra layer that PostgreSQL has which is
different than other RDBMs.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergei Kornilov 2018-02-15 10:59:26 Missed pgq_coop and pgq_ext in actual pgdg repository
Previous Message PG Bug reporting form 2018-02-15 07:16:03 BUG #15068: PostgreSQL doesn't support queries that involve columns from multiple databases