create or replace

[dwins]

From the mailing list:

The sql script generates many "create table" statements. It could be usefull to add "drop table if exist" before in case of update of the map.

[dwins]

We could actually use "CREATE OR REPLACE." http://www.postgresql.org/docs/9.0/static/sql-createtable.html

[nseinlet]

as you wish : $ git diff diff --git a/src/main/scala/FileSystem.scala b/src/main/scala/FileSystem.scala index 9c8992d..83f1d28 100644 --- a/src/main/scala/FileSystem.scala +++ b/src/main/scala/FileSystem.scala @@ -67,6 +67,7 @@ class FileSystem(out: java.io.File) extends Mapnik2GeoTools.Output { val cleanName = name.replaceAll("[\s-]", "_"); val wrapper = """

• DROP TABLE IF EXISTS """ + cleanName +"""; CREATE TABLE """ + cleanName + """ AS SELECT """ + where + """; ALTER TABLE """ + cleanName + """ ADD COLUMN id SERIAL; ALTER TABLE """ + cleanName + """ ADD PRIMARY KEY (id);

[nseinlet]

not tested : $ git diff diff --git a/src/main/scala/FileSystem.scala b/src/main/scala/FileSystem.scala index 9c8992d..63ffb1c 100644 --- a/src/main/scala/FileSystem.scala +++ b/src/main/scala/FileSystem.scala @@ -67,7 +67,7 @@ class FileSystem(out: java.io.File) extends Mapnik2GeoTools.Output { val cleanName = name.replaceAll("[\s-]", "_"); val wrapper = """

• CREATE TABLE """ + cleanName + """ AS SELECT """ + where + """;
• CREATE OR REPLACE TABLE """ + cleanName + """ AS SELECT """ + where + """; ALTER TABLE """ + cleanName + """ ADD COLUMN id SERIAL; ALTER TABLE """ + cleanName + """ ADD PRIMARY KEY (id); INSERT INTO geometry_columns VALUES ( '', 'public', '""" + cleanName + """', 'way', 2, 900913, 'GEOMETRY');