Skip site navigation (1) Skip section navigation (2)

Re: cross-database references are not implemented

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: "Paul Dam" <p(dot)dam(at)amyyon(dot)nl>
Subject: Re: cross-database references are not implemented
Date: 2008-06-03 13:57:17
Message-ID: 200806030657.17492.aklaver@comcast.net (view raw or flat)
Thread:
Lists: pgsql-sql
On Tuesday 03 June 2008 6:12 am, Paul Dam wrote:
> Hoi,
>
>
>
> I have a database with 2 schemas:
>
> - public
>
> - export
>
>
>
> In the export schema I have tables that are filled during an export
> process.
>
> There is some data I want to have in a table in the public schema as
> well.
>
> I wrote a trigger function that after insert in the export table does an
> export in the public table.
>
>
>
> If I do an insert I get the error message: "ERROR:  cross-database
> references are not implemented".
>
>
>
> How can I solve this?
>
>
>
> Met vriendelijke groet,
>
>
>
> Paul Dam

You will need to show the actual query, but I suspect you have an extra period 
in your table name. Instead of public.table_name you have something like 
public.table.name.
-- 
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Responses

pgsql-sql by date

Next:From: Ivan Sergio BorgonovoDate: 2008-06-03 13:57:45
Subject: Re: function returning result set of varying column
Previous:From: Pavel StehuleDate: 2008-06-03 13:54:41
Subject: Re: function returning result set of varying column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group