<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html lang="en">
<head><meta http-equiv="Content-Type" content="text/html;">
<title>Scalix message content</title>
<style type="text/css">
<!--
.Normal { text-align: left; text-indent:0pt; margin-top:0pt; margin-bottom:0pt; font-family: Arial; font-size: 12pt; }
.Default_Paragraph_Font {font-family: Arial; color: Black; background-color: white ; font-size: 12pt; font-weight: normal; font-style: normal; font-variant: normal; vertical-align: normal; text-decoration: none;}
div.ltTOCtitle { font-family: Verdana; font-size: 8pt; font-weight: bold; text-align: center;}
div.ltTOCl1 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:32pt; text-indent:-32pt;}
div.ltTOCl2 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:40pt; text-indent:-32pt;}
div.ltTOCl3 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:48pt; text-indent:-32pt;}
div.ltTOCl4 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:56pt; text-indent:-32pt;}
div.ltTOCl5 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:64pt; text-indent:-32pt;}
div.ltTOCl6 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:72pt; text-indent:-32pt;}
-->
</style>
</head>
<body>
<div class="Normal"><span style='font-size: 10pt; '>Marcus,</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Now it works! Thank you very
much. </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>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:</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>"Layer
'public.<table>' is not available"</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>GRASS 6.2-cvs</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Best Regards
</span><br><span style='font-size: 10pt; '>Horst</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>------------------------------------------------</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Dr. Horst
Düster</span><br><span style='font-size: 10pt; '>GIS-Koordinator, Stv.
Amtschef</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Kanton
Solothurn</span><br><span style='font-size: 10pt; '>Bau- und
Justizdepartement</span><br><span style='font-size: 10pt; '>Amt für
Geoinformation</span><br><span style='font-size: 10pt; '>SO!GIS
Koordination</span><br><span style='font-size: 10pt; '>Rötistrasse
4</span><br><span style='font-size: 10pt; '>CH-4501 Solothurn</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Telefon ++41(0)32 627 25
32</span><br><span style='font-size: 10pt; '>Telefax ++41(0)32 627 22
14</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>mailto:horst.duester@bd.so.ch</span><br><span style='font-size: 10pt; '>http://www.agi.so.ch</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>-----Ursprüngliche
Nachricht-----</span><br><span style='font-size: 10pt; '>Von: Markus Neteler
[mailto:neteler@fbk.eu]</span><br><span style='font-size: 10pt; '>Gesendet am:
Samstag, 24. November 2007 14:44</span><br><span style='font-size: 10pt; '>An:
Düster Horst</span><br><span style='font-size: 10pt; '>Cc:
grass-user</span><br><span style='font-size: 10pt; '>Betreff: Re: [GRASS-user]
v.in.ogr doesn't support Postgres Data
Type</span><br><span style='font-size: 10pt; '>timestamp</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Confirmed for 6.2.2. It
works in 6.3.x.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>The complete test sequence
is:</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>CREATE TABLE
test</span><br><span style='font-size: 10pt; '>(</span><br><span style='font-size: 10pt; '>id
serial NOT NULL,</span><br><span style='font-size: 10pt; '>mytime timestamp
DEFAULT now(),</span><br><span style='font-size: 10pt; '>text
varchar,</span><br><span style='font-size: 10pt; '>wkb_geometry
geometry,</span><br><span style='font-size: 10pt; '>CONSTRAINT test_pkey PRIMARY
KEY
(id)</span><br><span style='font-size: 10pt; '>)</span><br><span style='font-size: 10pt; '>WITHOUT
OIDS;</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>INSERT INTO test (text,
wkb_geometry)</span><br><span style='font-size: 10pt; '>VALUES
('Name',geometryFromText('POLYGON((600000
200000,650000</span><br><span style='font-size: 10pt; '>200000,650000
250000,600000 250000,600000 200000))',-1));</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '># this was missing in below
example:</span><br><span style='font-size: 10pt; '>select AddGeometryColumn
('postgis', 'test', 'geometry', -1, 'GEOMETRY', 2);</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>#
import</span><br><span style='font-size: 10pt; '>v.in.ogr dsn="PG:host=localhost
dbname=postgis user=neteler" layer=test
\</span><br><span style='font-size: 10pt; '> output=test
type=boundary,centroid</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>I have now backported a set
of changes:</span><br><span style='font-size: 10pt; '>- PG driver:
PG_TYPE_POSTGIS_GEOM and views
backported</span><br><span style='font-size: 10pt; '>- v.in.ogr: OFTDate,
OFTTime and OFTDateTime backported</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>It now
works:</span><br><span style='font-size: 10pt; '>v.db.select
test</span><br><span style='font-size: 10pt; '>cat|id|mytime|text</span><br><span style='font-size: 10pt; '>1|1|2007-11-24
13:03:49|Name</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>To avoid another 6.2.3
release candidate, please
download</span><br><span style='font-size: 10pt; '>http://grass.itc.it/grass62/source/snapshot/</span><br><span style='font-size: 10pt; '>->
grass-6.2.cvs_src_snapshot_2007_11_24.tar.gz</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>and give it a try. I have
created the snapshot again to</span><br><span style='font-size: 10pt; '>include
these changes.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Markus</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>On Fri, Nov 23, 2007 at
02:40:44PM +0100, Düster Horst
wrote:</span><br><span style='font-size: 10pt; '>> v.in.ogr v.in.ogr
doesn't support Postgres Data Type timestamp. When
you</span><br><span style='font-size: 10pt; '>> try to import PostGIS
layer with columns of type timestamp
v.in.ogr</span><br><span style='font-size: 10pt; '>> reports the error
p.e.:</span><br><span style='font-size: 10pt; '>> table xxx has 4 columns
6 values were supplied</span><br><span style='font-size: 10pt; '>> This
example error happens when table xxx hat 2 colums of 6 columns
with</span><br><span style='font-size: 10pt; '>> type timestamp. It seems
that v.in.ogr detects the wrong number
of</span><br><span style='font-size: 10pt; '>> columns.Isn't is possible
to convert timestamp data to character
data?</span><br><span style='font-size: 10pt; '>>
Regards</span><br><span style='font-size: 10pt; '>>
Horst</span><br><span style='font-size: 10pt; '>>
------------------------------------------------</span><br><span style='font-size: 10pt; '>>
Dr. Horst Duester</span><br><span style='font-size: 10pt; '>>
GIS-Koordinator, Stv. Amtschef</span><br><span style='font-size: 10pt; '>>
Kanton Solothurn</span><br><span style='font-size: 10pt; '>> Bau- und
Justizdepartement</span><br><span style='font-size: 10pt; '>> Amt fuer
Geoinformation</span><br><span style='font-size: 10pt; '>> SO!GIS
Koordination</span><br><span style='font-size: 10pt; '>> Roetistrasse
4</span><br><span style='font-size: 10pt; '>> CH-4501
Solothurn</span><br><span style='font-size: 10pt; '>> Telefon ++41(0)32
627 25 32</span><br><span style='font-size: 10pt; '>> Telefax ++41(0)32
627 22 14</span><br><span style='font-size: 10pt; '>>
mailto:horst.duester@bd.so.ch</span><br><span style='font-size: 10pt; '>>
http://www.agi.so.ch</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Content-Description:
ATT00001</span><br><span style='font-size: 10pt; '>>
_______________________________________________</span><br><span style='font-size: 10pt; '>>
grass-user mailing list</span><br><span style='font-size: 10pt; '>>
grass-user@lists.osgeo.org</span><br><span style='font-size: 10pt; '>>
http://lists.osgeo.org/mailman/listinfo/grass-user</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>--
</span><br><span style='font-size: 10pt; '>Markus Neteler <neteler fbk
eu>
http://mpa.fbk.eu/markus/</span><br><span style='font-size: 10pt; '>FBK-irst -
Centro per la Ricerca Scientifica e
Tecnologica</span><br><span style='font-size: 10pt; '>MPBA - Predictive Models
for Biol. & Environ. Data
Analysis</span><br><span style='font-size: 10pt; '>Via Sommarive, 18 -
38050 Povo (Trento), Italy</span><br><span style='font-size: 10pt; '>New book:
http://www.grassbook.org/</span></div>
</body>
</html>