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();

CREATE OR REPLACE FUNCTION dorojnaya_set1_update()
  RETURNS trigger AS
$BODY$
   BEGIN 
         perform dblink_connect('hostaddr=192.168.50.111 port=5432 dbname=topo2000 user=alimuradov password=5vn63ys9');
	 perform dblink_exec('insert into dorojnaya_set(id_0 INTEGER, the_geom GEOMETRY, objectcode TEXT, objectkey TEXT, objectid TEXT) values ('||NEW.id||','''||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 OR REPLACE FUNCTION dorojnaya_set1_update()
  RETURNS trigger AS
$BODY$
   BEGIN 
         perform dblink_connect('hostaddr=192.168.50.111 port=5432 dbname=db user=user password=password');
	 perform dblink_exec('insert into dorojnaya_set(id_0, the_geom, objectcode, objectkey, objectid) values ('||NEW.id::text||'::TEXT,'''||NEW.the_geom::text||'''::GEOMETRY,'''||NEW.objectcode::text||'''::TEXT,'''||NEW.objectkey::text||'''::TEXT,'''||NEW.objectid::text||'''::TEXT);'); 	
         perform dblink_disconnect(); 
       RETURN NEW;
   END;
$BODY$

Мне легче отталкиваться на работающих примерах, чем курить документацию. 

CREATE TABLE dorojnaya_set
(
  id integer NOT NULL DEFAULT nextval('dorojnaya_set_id_0_seq'::regclass),
  the_geom geometry(MultiPolygon,900920),
  sem32768 character varying(254),
  sem32769 character varying(254),
  sem9 character varying(254),
  sem11 numeric,
  sem97 character varying(64),
  sem4 numeric,
  sem31 character varying(64),
  sem3 character varying(64),
  sem40 character varying(64),
  sem51 numeric,
  sem54 character varying(64),
  sem250 character varying(254),
  sem90 character varying(64),
  sem1 numeric,
  sem55 character varying(64),
  sem10 character varying(64),
  sem57 character varying(64),
  sem84 character varying(64),
  sem44 character varying(64),
  sem46 numeric,
  sem50 numeric,
  sem53 numeric,
  sem208 numeric,
  sem210 numeric,
  sem35 character varying(64),
  sem21 character varying(64),
  objectcode character varying(24),
  objectkey character varying(64),
  objectid character varying(24),
  objectname character varying(254),
  CONSTRAINT dorojnaya_set_pkey PRIMARY KEY (id )
)

CREATE OR REPLACE VIEW rastitelnos_line_10000 AS 
 SELECT *
   FROM rastitelnos_line
  WHERE (rastitelnos_line.objectkey !~ 'L0071131000') OR (rastitelnos_line.objectkey !~ 'L0071131100') OR (rastitelnos_line.objectkey !~ 'L0071224000') OR (rastitelnos_line.objectkey IS NULL);

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

WHERE (rastitelnos_line.objectkey !~ 'L0071131000') OR (rastitelnos_line.objectkey !~ 'L0071131100') OR (rastitelnos_line.objectkey !~ 'L0071224000') OR (rastitelnos_line.objectkey IS NULL);

WHERE rastitelnos_line.objectkey !~ 'L0071224000' OR rastitelnos_line.objectkey IS NULL;

CREATE OR REPLACE VIEW rastitelnos_line_10000 AS 
 SELECT *
   FROM rastitelnos_line
  WHERE ((rastitelnos_line.objectkey != 'L0071131000') AND (rastitelnos_line.objectkey !='L0071131100') AND (rastitelnos_line.objectkey != 'L0071224000')) OR (rastitelnos_line.objectkey IS NULL);

  ALTER TABLE rastitelnos_line_10000
  OWNER TO alimuradov;
GRANT ALL ON TABLE rastitelnos_line_10000 TO alimuradov;

CREATE OR REPLACE VIEW rastitelnos_line_10000 AS 
 SELECT *
   FROM rastitelnos_line
  WHERE rastitelnos_line.objectkey NOT IN ('L0071131000','L0071131100','L0071224000') OR rastitelnos_line.objectkey IS NULL;

  ALTER TABLE rastitelnos_line_10000
  OWNER TO alimuradov;
GRANT ALL ON TABLE rastitelnos_line_10000 TO alimuradov;

WHERE rastitelnos_line.objectkey NOT IN ('L0071131000','L0071131100','L0071224000') OR rastitelnos_line.objectkey IS NULL;

WHERE rastitelnos_line.objectkey::text <> 'L0071131000'::text AND rastitelnos_line.objectkey::text <> 'L0071131100'::text AND rastitelnos_line.objectkey::text <> 'L0071224000'::text;