On 9/29/2011 1:36 AM, Even Rouault wrote:
Le mercredi 28 septembre 2011 21:28:26, Even Rouault a écrit :
Le jeudi 22 septembre 2011 17:48:29, Andy Colson a écrit :
Hi List,
I'm using ogr2ogr to convert (and reproject) data from shapefile to PG,
if I use insert statements the null dates
On 9/29/2011 11:28 AM, Even Rouault wrote:
Selon Andy Colsona...@squeakycode.net:
On 9/29/2011 1:36 AM, Even Rouault wrote:
Le mercredi 28 septembre 2011 21:28:26, Even Rouault a écrit :
Le jeudi 22 septembre 2011 17:48:29, Andy Colson a écrit :
Hi List,
I'm using ogr2ogr to convert
Sorry to keep pestering. Is there a better place I should be seeking
help? Would a $bounty$ help?
-Andy
On 9/22/2011 10:48 AM, Andy Colson wrote:
Hi List,
I'm using ogr2ogr to convert (and reproject) data from shapefile to PG,
if I use insert statements the null dates are not a problem
...@lists.osgeo.org]
De la part de Andy Colson
Envoyé : Wednesday, 28 September 2011 4:50 PM
À : gdal-dev@lists.osgeo.org
Objet : Re: [gdal-dev] PostgreSQL
Sorry to keep pestering. Is there a better place I should be seeking help?
Would a $bounty$ help?
-Andy
On 9/22/2011 10:48 AM, Andy Colson
uploading ? (you could
set them back once they'r up there, as well as perform the reprojection). i've
never tried to use nulls in shapes before. can sqllite be used as an
intermediatry instead ?
-i
-Message d'origine-
De : Andy Colson [mailto:a...@squeakycode.net]
Envoyé : Wednesday, 28
Would a 16Meg .zip file, that extracts to 157Meg, be acceptable in Trac?
I attempted to copy some records out, but it created the new shapefile
with a type of ftString instead of ftDate.
-Andy
On 9/28/2011 2:28 PM, Even Rouault wrote:
Le jeudi 22 septembre 2011 17:48:29, Andy Colson a écrit
On 9/28/2011 2:28 PM, Even Rouault wrote:
On another layer, regardless of insert/copy, I'm getting:
ERROR: numeric field overflow
DETAIL: A field with precision 19, scale 11 must round to an absolute
value less than 10^8.
CONTEXT: COPY poltwppoly, line 1, column shape_area:
On Thu, Sep 22, 2011 at 9:18 PM, Andy Colson a...@squeakycode.net
mailto:a...@squeakycode.net wrote:
Hi List,
I'm using ogr2ogr to convert (and reproject) data from shapefile to PG, if
I use insert statements the null dates are not a problem, but if I set
PG_USE_COPY=YES, then I get
Hi List,
I'm using ogr2ogr to convert (and reproject) data from shapefile to PG,
if I use insert statements the null dates are not a problem, but if I
set PG_USE_COPY=YES, then I get errors:
ERROR 1: COPY statement failed.
ERROR: date/time field value out of range: /00/00
CONTEXT: COPY
