Marcus, Now it works! Thank you very much.
But during testing I'm running into the next problem of schma support. When I load a layer from schema different to public the schema support works fine. But when I load a layer residing in public schema with "public.<table>" v.in.ogr is not able to load this layer. GRASS responses with: "Layer 'public.<table>' is not available" GRASS 6.2-cvs Best Regards Horst ------------------------------------------------ Dr. Horst Düster GIS-Koordinator, Stv. Amtschef Kanton Solothurn Bau- und Justizdepartement Amt für Geoinformation SO!GIS Koordination Rötistrasse 4 CH-4501 Solothurn Telefon ++41(0)32 627 25 32 Telefax ++41(0)32 627 22 14 mailto:[EMAIL PROTECTED] http://www.agi.so.ch -----Ursprüngliche Nachricht----- Von: Markus Neteler [mailto:[EMAIL PROTECTED] Gesendet am: Samstag, 24. November 2007 14:44 An: Düster Horst Cc: grass-user Betreff: Re: [GRASS-user] v.in.ogr doesn't support Postgres Data Type timestamp Confirmed for 6.2.2. It works in 6.3.x. The complete test sequence is: CREATE TABLE test ( id serial NOT NULL, mytime timestamp DEFAULT now(), text varchar, wkb_geometry geometry, CONSTRAINT test_pkey PRIMARY KEY (id) ) WITHOUT OIDS; INSERT INTO test (text, wkb_geometry) VALUES ('Name',geometryFromText('POLYGON((600000 200000,650000 200000,650000 250000,600000 250000,600000 200000))',-1)); # this was missing in below example: select AddGeometryColumn ('postgis', 'test', 'geometry', -1, 'GEOMETRY', 2); # import v.in.ogr dsn="PG:host=localhost dbname=postgis user=neteler" layer=test \ output=test type=boundary,centroid I have now backported a set of changes: - PG driver: PG_TYPE_POSTGIS_GEOM and views backported - v.in.ogr: OFTDate, OFTTime and OFTDateTime backported It now works: v.db.select test cat|id|mytime|text 1|1|2007-11-24 13:03:49|Name To avoid another 6.2.3 release candidate, please download http://grass.itc.it/grass62/source/snapshot/ -> grass-6.2.cvs_src_snapshot_2007_11_24.tar.gz and give it a try. I have created the snapshot again to include these changes. Markus On Fri, Nov 23, 2007 at 02:40:44PM +0100, Düster Horst wrote: > v.in.ogr v.in.ogr doesn't support Postgres Data Type timestamp. When you > try to import PostGIS layer with columns of type timestamp v.in.ogr > reports the error p.e.: > table xxx has 4 columns 6 values were supplied > This example error happens when table xxx hat 2 colums of 6 columns with > type timestamp. It seems that v.in.ogr detects the wrong number of > columns.Isn't is possible to convert timestamp data to character data? > Regards > Horst > ------------------------------------------------ > Dr. Horst Duester > GIS-Koordinator, Stv. Amtschef > Kanton Solothurn > Bau- und Justizdepartement > Amt fuer Geoinformation > SO!GIS Koordination > Roetistrasse 4 > CH-4501 Solothurn > Telefon ++41(0)32 627 25 32 > Telefax ++41(0)32 627 22 14 > mailto:[EMAIL PROTECTED] > http://www.agi.so.ch Content-Description: ATT00001 > _______________________________________________ > grass-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-user -- Markus Neteler <neteler fbk eu> http://mpa.fbk.eu/markus/ FBK-irst - Centro per la Ricerca Scientifica e Tecnologica MPBA - Predictive Models for Biol. & Environ. Data Analysis Via Sommarive, 18 - 38050 Povo (Trento), Italy New book: http://www.grassbook.org/
_______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
