Re: cross-database references are not implemented - Mailing list pgsql-sql

From Paul Dam
Subject Re: cross-database references are not implemented
Date
Msg-id 28DD271C986F234A9B4573938292C1B3048626@s0008.a-more.org
Whole thread Raw
In response to Re: cross-database references are not implemented  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-sql
Thanks Adrian,

I casted a column to a type with "value::<schema>.<table>.<column>%type"
That was the problem.

Met vriendelijke groet,
Paul Dam

-----Oorspronkelijk bericht-----
Van: Adrian Klaver [mailto:aklaver@comcast.net]
Verzonden: dinsdag 3 juni 2008 15:57
Aan: pgsql-sql@postgresql.org
CC: Paul Dam
Onderwerp: Re: [SQL] cross-database references are not implemented

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@comcast.net


pgsql-sql by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: function returning result set of varying column
Next
From: "maria s"
Date:
Subject: Re: function returning result set of varying column