Hello it works for me
postgres=# create schema export; CREATE SCHEMA Time: 45,918 ms postgres=# create table public.a(a varchar); CREATE TABLE Time: 91,385 ms postgres=# create table export.a(a varchar); \CREATE TABLE Time: 9,462 ms postgres=# create function ftrg() returns trigger as $$begin insert into export.a values(new.*); return new; end$$ language plpgsql; CREATE FUNCTION Time: 486,395 ms postgres=# \h CREATE trigger Command: CREATE TRIGGER Description: define a new trigger Syntax: CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } ON table [ FOR [ EACH ] { ROW | STATEMENT } ] EXECUTE PROCEDURE funcname ( arguments ) postgres=# CREATE TRIGGER aaa after insert on public.a for each row execute procedure ftrg(); CREATE TRIGGER Time: 5,848 ms postgres=# insert into public.a values('ahoj'); INSERT 0 1 Time: 5,179 ms postgres=# SELECT * from export.a ; a ------ ahoj (1 row) postgresql 8.3 Pavel 2008/6/3 Paul Dam <[EMAIL PROTECTED]>: > 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql