cross-database references are not implemented

Поиск
Список
Период
Сортировка
От Paul Dam
Тема cross-database references are not implemented
Дата
Msg-id 28DD271C986F234A9B4573938292C1B3048624@s0008.a-more.org
обсуждение исходный текст
Ответы Re: cross-database references are not implemented  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: cross-database references are not implemented  (Adrian Klaver <aklaver@comcast.net>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hoi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I have a database with 2 schemas:</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">- public</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">- export</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">In the export schema I have tables that are filled during an export process.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">There is some data I want to have in a table in the public schema as well.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">I wrote a trigger function that after insert in the export table does an export in the public
table.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">If I do an insert I get the error message: "ERROR:  cross-database references are not
implemented".</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">How can I solve this?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="NL"
style="font-size:10.0pt;
font-family:Arial">Met vriendelijke groet,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="NL"style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span lang="NL"
style="font-size:12.0pt">PaulDam</span></font></div> 

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

Предыдущее
От: "maria s"
Дата:
Сообщение: Re: function returning result set of varying column
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: cross-database references are not implemented