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 [EMAIL PROTECTED] -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql