[Tile-serving] [osm2pgsql] Added the capability to specify a target schema for the tables. (#173)

[Paul Norman]

> I thought I tried that, but maybe not. I'll test it soon and see.

The answer is no

```
[pnorman at pippin /usr/home/pnorman/osm/osm2pgsql]$ ./osm2pgsql -S default.style --prefix 'test.planet_osm' tests/liechtenstein-2013-08-03.osm.pbf
osm2pgsql SVN version 0.87.0 (64bit id space)

Using built-in tag processing pipeline
Using projection SRS 900913 (Spherical Mercator)
Setting up table: test.planet_osm_point
Osm2pgsql failed due to ERROR: SELECT AddGeometryColumn('test.planet_osm_point', 'way', 900913, 'POINT', 2 ) failed: ERROR:  Table 'test.planet_osm_point' does not occur in the search_path
CONTEXT:  SQL statement "SELECT AddGeometryColumn('','',$1,$2,$3,$4,$5, $6)"
PL/pgSQL function addgeometrycolumn(character varying,character varying,integer,character varying,integer,boolean) line 5 at SQL statement
```

So I agree with this patch in principle, but it needs rebasing against C++ with updates to docs/usage.md and to the count of command line options in README.md

Also, at some point we should probably move to the type-based postgis system which doesn't call AddGeometryColumn.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/173#issuecomment-65510522
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20141203/39c7117a/attachment.html>