PostGIS 使用Mysql_fdw同步ArcGIS填坑记录

##实现Mysql_fdw数据同步过程中，出现过很多坑，开此贴记录一下

1、触发器记录

这里insert的时候，采用过insert into f_pressureline select new.*，出现objectid永远插入为0的情况，所以改动如下：

CREATE OR REPLACE FUNCTION func_pressureline()
RETURNS trigger AS
$BODY$
BEGIN
if (TG_OP = 'DELETE') then
delete from f_pressureline where objectid = OLD.objectid;
return old;
elsif (TG_OP = 'UPDATE') then
update f_pressureline set hasattachm = new.hasattachm where objectid = OLD.objectid;
return new;
elsif (TG_OP = 'INSERT') then
insert into f_pressureline (objectid,pipelength, crttime, pipediam,pipematerial,location,burieddate,pipelinelayingmethod,areacode,companycode,crtuser) values (new.objectid,new.pipelength,new.crttime,new.pipediam,new.pipematerial,new.location,new.burieddate,new.pipelinelayingmethod,new.areacode,new.companycode,new.crtuser) ;
return new;
end if;
return null;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION func_pressureline()
OWNER TO sde;