Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Paquier
Subject Re: BUG #15068: PostgreSQL doesn't support queries that involvecolumns from multiple databases
Date
Msg-id 20180215074314.GA25356@paquier.xyz
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 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
Attachment

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15068: PostgreSQL doesn't support queries that involve columnsfrom multiple databases
Next
From: Sergei Kornilov
Date:
Subject: Missed pgq_coop and pgq_ext in actual pgdg repository