CREATE TABLE pokritiya
(
  id serial NOT NULL,
  the_geom geometry(MultiPolygon,900920),
  sem3 character varying(64),
  sem9 character varying(254),
  sem11 double precision,
  sem40 character varying(64),
  sem32768 character varying(254),
  sem32769 character varying(254),
  sem97 character varying(64),
  sem10 character varying(64),
  sem55 character varying(64),
  objectcode character varying(24),
  objectkey character varying(64),
  objectid character varying(24),
  objectname character varying(254),
  CONSTRAINT pokritiya_pkey PRIMARY KEY (id )
)

CREATE TABLE pokritiya
(
  id serial NOT NULL,
  the_geom geometry(MultiPolygon,900920),
  sem3 character varying(64),
  objectcode character varying(24),
  objectkey character varying(64),
  objectid character varying(24),
  objectname character varying(254),
  CONSTRAINT pokritiya_pkey PRIMARY KEY (id )
)

CREATE OR REPLACE FUNCTION granitsy_update()
  RETURNS trigger AS
$BODY$
   BEGIN 
         id=(id из аналогичной  таблицы в  другой бд)
         the_geom = (the_geom из аналогичной  таблицы в  другой бд )
         NEW.created:=current_timestamp;
         NEW.created_by:=session_user; 
       RETURN NEW;
   END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION granitsy_update()
  OWNER TO redaktor_granits;

CREATE OR REPLACE FUNCTION dorojnaya_set_update()
  RETURNS trigger AS
$BODY$
   BEGIN 
         NEW.id=topo2000.public.dorojnaya_set.id;
         NEW.objectcode=topo2000.public.dorojnaya_set.objectcode;
         NEW.objectkey=topo2000.public.dorojnaya_set.objectkey;
         NEW.objectid=topo2000.public.dorojnaya_set.objectid;
         NEW.the_geom=topo2000.public.dorojnaya_set.the_geom; 
       RETURN NEW;
   END;
$BODY$

Ошибки источника:
      Ошибка PostGIS при добавлении объектов: ОШИБКА:  ссылки между базами не реализованы: topo2000.public.dorojnaya_set.id
    СТРОКА 1: SELECT topo2000.public.dorojnaya_set.id
                     ^
    ЗАПРОС:  SELECT topo2000.public.dorojnaya_set.id
    КОНТЕКСТ:  функция PL/pgSQL dorojnaya_set_update(), строка 3, оператор присваивание
    

CREATE OR REPLACE VIEW dorojnaya_set_10000 AS 
 SELECT dorojnaya_set.id,
    dorojnaya_set.the_geom,
    dorojnaya_set.sem9,
    dorojnaya_set.sem11,
    dorojnaya_set.objectcode,
    dorojnaya_set.objectkey,
    dorojnaya_set.objectid,
    dorojnaya_set.objectname
   FROM dorojnaya_set WHERE objectkey !~ 'P0062150000';

ALTER TABLE dorojnaya_set_10000
  OWNER TO gisgroup;
GRANT ALL ON TABLE dorojnaya_set_10000 TO gisgroup;

CREATE OR REPLACE FUNCTION pokritiya_update()
  RETURNS trigger AS
$BODY$
   BEGIN 
         id=(id из аналогичной  таблицы в  другой бд)
         the_geom = (the_geom из аналогичной  таблицы в  другой бд )
         NEW.created:=current_timestamp;
         NEW.created_by:=session_user; 
       RETURN NEW;
   END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION pokritiya_update()
  OWNER TO redaktor_granits;

CREATE OR REPLACE FUNCTION dorojnaya_set1_update()
  RETURNS trigger AS
$BODY$
   BEGIN 
         perform dblink_connect('hostaddr=***.***.***.** port=5432 dbname=*** user=***** password=*****');
	 perform dblink_exec('insert into dorojnaya_set(id_0, the_geom, objectcode, objectkey, objectid ) values ('||NEW.id_0||','''||NEW.the_geom||''','''||NEW.objectcode||''','''||NEW.objectkey||''','''||NEW.objectcid||''');');	
         perform dblink_disconnect(); 
       RETURN NEW;
   END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION dorojnaya_set1_update()
  OWNER TO gisgroup;

CREATE TRIGGER dorojnaya_set1_update
  BEFORE INSERT OR UPDATE
  ON dorojnaya_set
  FOR EACH ROW
  EXECUTE PROCEDURE dorojnaya_set1_update();