'Relation already exists' pgrouting 中的错误

Question

我正在用下面的sql创建一个表:

-- Table: buildings
-- DROP TABLE buildings;
CREATE TABLE buildings
(
osm_id integer NOT NULL,
"name" character varying(255),
"type" character varying(255),
"geometry" geometry,
CONSTRAINT enforce_dims_geometry CHECK (st_ndims(geometry) = 2)
)
WITH (
OIDS=FALSE
);
ALTER TABLE buildings OWNER TO "user";

然后，尝试用来自另一个表的数据填充表:

    SELECT osm_id, way
INTO buildings
FROM planet_osm_polygon
WHERE building='yes'

我得到以下错误:

错误:关系"buildings"已经存在

* * * 误差 * * *

错误:关系"buildings"已经存在SQL state: 42P07

你知道为什么会这样吗?我是注浆新手，正在努力弄清楚如何进行。

谢谢!

Answer 1

您的命令

SELECT osm_id, way
INTO buildings
FROM planet_osm_polygon
WHERE building='yes'

正在创建已经创建的表建筑物，这就是为什么你得到这个错误。