AW: Re: [GRASS-user] v.in.ogr doesn't support Postgres Data Type timestamp

[Düster Horst]

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:horst.duester at bd.so.ch
http://www.agi.so.ch



-----Ursprüngliche Nachricht-----
Von: Markus Neteler [mailto:neteler at fbk.eu]
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:horst.duester at bd.so.ch
>    http://www.agi.so.ch

Content-Description: ATT00001
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> 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/

-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20071126/93ef0085/attachment-0001.html