[OSM-Devserver] Request to Install Hstore In osmosisci_pgsql06

Sven Geggus lists at fuchsschwanzdomain.de
Mi Aug 25 17:08:12 CEST 2010


Brett Henderson <brett at bretth.com> wrote:

> Yep, that's fine.  Thanks for the help.

OK, I just dropped your database and created a new one with postgis and
hstore-new:

osmosisci_pgsql06=# \d
               Liste der Relationen
 Schema |       Name       |   Typ   | Eigentümer 
--------+------------------+---------+------------
 public | geometry_columns | Tabelle | osmosisci
 public | spatial_ref_sys  | Tabelle | osmosisci
(2 Zeilen)
osmosisci_pgsql06=# create table foobar (tags hstore, way geometry);
CREATE TABLE
osmosisci_pgsql06=# \d foobar
    Tabelle »public.foobar«
 Spalte |   Typ    | Attribute 
--------+----------+-----------
 tags   | hstore   | 
 way    | geometry | 

osmosisci_pgsql06=# select DropGeometryTable('foobar');
   dropgeometrytable    
------------------------
 public.foobar dropped.
(1 Zeile)

Regards

Sven

-- 
"Das Einzige, wovor wir Angst haben sollten, ist die Angst selbst"
(Franklin D. Roosevelt)

/me is giggls at ircnet, http://sven.gegg.us/ on the Web