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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Sergio Borgonovo | 2008-06-03 13:57:45 | Re: function returning result set of varying column |
Previous Message | Pavel Stehule | 2008-06-03 13:54:41 | Re: function returning result set of varying column |