[Tile-serving] [openstreetmap/osm2pgsql] Schema support (#619)

[Paul Norman]

I want schema support (see past PRs) but it's surprisingly tricky to do

* This changes the default behavior from using the default schema to using public.

* There are lots of test failures. e.g.

  ```
2/25 Testing: test-hstore-match-only
2/25 Test: test-hstore-match-only
Command: "/home/pnorman/osm/osm2pgsql/build/tests/test-hstore-match-only"
Directory: /home/pnorman/osm/osm2pgsql
"test-hstore-match-only" start time: Aug 24 16:25 PDT
Output:
----------------------------------------------------------
NOTICE:  database "osm2pgsql-test-32244-1472081104" does not exist, skipping
Using built-in tag processing pipeline
Setting up table: ._point
ERROR: CREATE SCHEMA IF NOT EXISTS  failed: ERROR:  syntax error at end of input
LINE 1: CREATE SCHEMA IF NOT EXISTS
                                    ^
```

* We need to carefully test the schema option when there are already osm2pgsql tables in the search path.


-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/619#issuecomment-242551775
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20160825/7acd77cd/attachment.html>