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

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #15068: PostgreSQL doesn't support queries that involvecolumns from multiple databases
Дата
Msg-id 20180215074314.GA25356@paquier.xyz
обсуждение исходный текст
Ответ на BUG #15068: PostgreSQL doesn't support queries that involve columnsfrom multiple databases  (PG Bug reporting form <noreply@postgresql.org>)
Список 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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15068: PostgreSQL doesn't support queries that involve columnsfrom multiple databases
Следующее
От: Sergei Kornilov
Дата:
Сообщение: Missed pgq_coop and pgq_ext in actual pgdg repository