Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict

2012-09-21 Thread Nicolas Ribot
Hi,

On this 1.5 version, query is raising an error but does not crash the server:
 PostgreSQL 9.1.5 on x86_64-apple-darwin11.4.0, compiled by
i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc.
build 5658) (LLVM build 2336.9.00), 64-bit
POSTGIS=1.5.3 GEOS=3.3.5-CAPI-1.7.5 PROJ=Rel. 4.8.0, 6 March
2012 LIBXML=2.7.3 USE_STATS

Using the geography data type, which I think is preferred in your
case, the query works:

SELECT ST_intersects(
   st_geogfromtext('POLYGON((31.904296875 67.32421875,14.58984375
67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))'),
   st_geogfromtext('POLYGON((31.904296875 67.32421875,14.58984375
67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))')
);

Nicolas


On 20 September 2012 18:29, Adam work@gmail.com wrote:
 Thx I was wondering how we could fix existing geometries.
 ST_SimplifyPreserveTopology did a nice job on the one I mentioned in the
 email.
 Still would like Postgis1.5 not to core dump on this condition though...


 On Thu, Sep 20, 2012 at 11:04 AM, Dave Potts dave.po...@pinan.co.uk wrote:

 I have used the jts library and have the same type of issue

 In jts you would

 1.  Try to use a buffer of 0.
 2.  Try calling one of the simplify geom operations.

 Dave.
 Adam wrote:
  Running this query against Postgis 1.5 causes a core dump:
  SELECT ST_intersects(
 geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
  67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
  67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326),
 geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
  67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
  67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326)
  );
 
  Running against Postgis 2.0 gives the following error (much preferred to
  get an error than a core dump!):
  ERROR:  GEOSIntersects: TopologyException: side location conflict at
  31.81640625 67.32421875
  CONTEXT:  SQL function st_intersects statement 1
 
  Both are using geos version: '3.3.5-CAPI-1.7.5'.
 
  Unfortunately upgrading to Postgis 2 is not an option for us.
  Our platform is Solaris 10 x86 using 64 bit builds.
 
 From dbx the core file shows:
[1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170,
  0xfd7fffdf8880,
  0x1b408d), at 0x1b408d
[2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
  0xfd7ffec416bc
[3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
  0xfd7ffec418a9
[4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in
  eh_throw.cc
[5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this =
  0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h
[6]
 
  _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this
  = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in
  EdgeEndStar.cpp
[7] geos::operation::relate::RelateComputer::labelNodeEdges(this =
  0xfd7fffdf8e30), line 327 in RelateComputer.cpp
[8] geos::operation::relate::RelateComputer::computeIM(this =
  0xfd7fffdf8e30), line 131 in RelateComputer.cpp
[9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)),
  line
  43 in RelateOp.cpp
[10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638),
  line 191 in memory
[11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)),
  line
  351 in geos_ts_c.cpp
[12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp
[13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in
  lwgeom_geos.c
[14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext =
  0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88
[15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull =
  0xbd6c28
  , isDone = (nil)), at 0x5aaf23
[16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at
  0x5ae659
[17] ExecResult(node = 0xbd5630), at 0x5ba7d0
[18] ExecProcNode(node = 0xbd5630), at 0x5a77ec
[19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction =
  ForwardScanDirection, count = 1), at 0x5a550c
[20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529
  ___
  postgis-users mailing list
  postgis-users@postgis.refractions.net
  http://postgis.refractions.net/mailman/listinfo/postgis-users
 


 --


 ___
 postgis-users mailing list
 postgis-users@postgis.refractions.net
 http://postgis.refractions.net/mailman/listinfo/postgis-users



 ___
 postgis-users mailing list
 postgis-users@postgis.refractions.net
 http://postgis.refractions.net/mailman/listinfo/postgis-users

___
postgis-users mailing list

Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict

2012-09-21 Thread Martin Davis
This occurs because the geometries are invalid, and the current 
intersects algorithm used in JTS/GEOS has kittens when invalid 
geometries are used as input.  The core dump thing is unfortunate (and 
obviously got fixed in later versions).


You might say surely this shouldn't cause such a serious error, and 
I'd agree.  Probably what should happen in the case of invalid 
geometries input to predicates is that they return a (possibly bogus) 
result.  You might then say but obviously they do intersect, so why 
can't the result be correct?, and in this case I'd also agree.  The 
intersects algorithm could be enhanced to detect intersection correctly 
in almost all cases, valid or not.  (Some of the other predicates might 
not be so tolerant - but still a best effort strategy would be nicer 
than outright failure).


But that's all work for the future (and get in touch if you have funding 
to offer!)


For now, all you can do is to check validity before running the 
ST_intersects function in some way. The nicest way to do this would be 
to create a new function which does the validity check internally.  And 
that function could also be enhanced to do some other kinds of 
intersection checks, to try and detect intersection for any inputs.  For 
instance, in this case ST_intersects could be run safely on the geometry 
boundary linework, and will then report the correct answer.  This could 
be supplemented with some point-in-polygon checks to catch the situation 
of disjoint boundaries.  Alternatively, if invalid polygons are detected 
the buffer(0) trick could be used to try and clean them.



On 9/20/2012 7:37 AM, Adam wrote:

Running this query against Postgis 1.5 causes a core dump:
SELECT ST_intersects(
   geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 
67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 
67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326),
   geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375 
67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875 
67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326)

);

Running against Postgis 2.0 gives the following error (much preferred 
to get an error than a core dump!):
ERROR:  GEOSIntersects: TopologyException: side location conflict at 
31.81640625 67.32421875

CONTEXT:  SQL function st_intersects statement 1

Both are using geos version: '3.3.5-CAPI-1.7.5'.

Unfortunately upgrading to Postgis 2 is not an option for us.
Our platform is Solaris 10 x86 using 64 bit builds.

From dbx the core file shows:
  [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 
0xfd7fffdf8880, 0x1b408d), at 0x1b408d
  [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 
0xfd7ffec416bc
  [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 
0xfd7ffec418a9
  [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 
in eh_throw.cc
  [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this = 
0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h
  [6] 
_ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this 
= 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp
  [7] geos::operation::relate::RelateComputer::labelNodeEdges(this = 
0xfd7fffdf8e30), line 327 in RelateComputer.cpp
  [8] geos::operation::relate::RelateComputer::computeIM(this = 
0xfd7fffdf8e30), line 131 in RelateComputer.cpp
  [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)), 
line 43 in RelateOp.cpp
  [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 
0x91b638), line 191 in memory
  [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)), 
line 351 in geos_ts_c.cpp

  [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp
  [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in 
lwgeom_geos.c
  [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext = 
0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88
  [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 
0xbd6c28 , isDone = (nil)), at 0x5aaf23
  [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), 
at 0x5ae659

  [17] ExecResult(node = 0xbd5630), at 0x5ba7d0
  [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec
  [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction = 
ForwardScanDirection, count = 1), at 0x5a550c

  [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529




___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


No virus found in this message.
Checked by AVG - www.avg.com http://www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5281 - Release Date: 09/20/12



___
postgis-users mailing list
postgis-users@postgis.refractions.net

[postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict

2012-09-20 Thread Adam
Running this query against Postgis 1.5 causes a core dump:
SELECT ST_intersects(
   geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326),
   geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326)
);

Running against Postgis 2.0 gives the following error (much preferred to
get an error than a core dump!):
ERROR:  GEOSIntersects: TopologyException: side location conflict at
31.81640625 67.32421875
CONTEXT:  SQL function st_intersects statement 1

Both are using geos version: '3.3.5-CAPI-1.7.5'.

Unfortunately upgrading to Postgis 2 is not an option for us.
Our platform is Solaris 10 x86 using 64 bit builds.

From dbx the core file shows:
  [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 0xfd7fffdf8880,
0x1b408d), at 0x1b408d
  [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
0xfd7ffec416bc
  [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
0xfd7ffec418a9
  [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in
eh_throw.cc
  [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this =
0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h
  [6]
_ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this
= 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp
  [7] geos::operation::relate::RelateComputer::labelNodeEdges(this =
0xfd7fffdf8e30), line 327 in RelateComputer.cpp
  [8] geos::operation::relate::RelateComputer::computeIM(this =
0xfd7fffdf8e30), line 131 in RelateComputer.cpp
  [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)), line
43 in RelateOp.cpp
  [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638),
line 191 in memory
  [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)), line
351 in geos_ts_c.cpp
  [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp
  [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in lwgeom_geos.c
  [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext =
0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88
  [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 0xbd6c28
, isDone = (nil)), at 0x5aaf23
  [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at
0x5ae659
  [17] ExecResult(node = 0xbd5630), at 0x5ba7d0
  [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec
  [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction =
ForwardScanDirection, count = 1), at 0x5a550c
  [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict

2012-09-20 Thread Dave Potts
I have used the jts library and have the same type of issue

In jts you would

1.  Try to use a buffer of 0.
2.  Try calling one of the simplify geom operations.

Dave.
Adam wrote:
 Running this query against Postgis 1.5 causes a core dump:
 SELECT ST_intersects(
geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326),
geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
 67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
 67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326)
 );

 Running against Postgis 2.0 gives the following error (much preferred to
 get an error than a core dump!):
 ERROR:  GEOSIntersects: TopologyException: side location conflict at
 31.81640625 67.32421875
 CONTEXT:  SQL function st_intersects statement 1

 Both are using geos version: '3.3.5-CAPI-1.7.5'.

 Unfortunately upgrading to Postgis 2 is not an option for us.
 Our platform is Solaris 10 x86 using 64 bit builds.

From dbx the core file shows:
   [1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170, 0xfd7fffdf8880,
 0x1b408d), at 0x1b408d
   [2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
 0xfd7ffec416bc
   [3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
 0xfd7ffec418a9
   [4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in
 eh_throw.cc
   [5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this =
 0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h
   [6]
 _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this
 = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp
   [7] geos::operation::relate::RelateComputer::labelNodeEdges(this =
 0xfd7fffdf8e30), line 327 in RelateComputer.cpp
   [8] geos::operation::relate::RelateComputer::computeIM(this =
 0xfd7fffdf8e30), line 131 in RelateComputer.cpp
   [9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)),
 line
 43 in RelateOp.cpp
   [10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638),
 line 191 in memory
   [11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)),
 line
 351 in geos_ts_c.cpp
   [12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp
   [13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in
 lwgeom_geos.c
   [14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext =
 0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88
   [15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull = 0xbd6c28
 , isDone = (nil)), at 0x5aaf23
   [16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at
 0x5ae659
   [17] ExecResult(node = 0xbd5630), at 0x5ba7d0
   [18] ExecProcNode(node = 0xbd5630), at 0x5a77ec
   [19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction =
 ForwardScanDirection, count = 1), at 0x5a550c
   [20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529
 ___
 postgis-users mailing list
 postgis-users@postgis.refractions.net
 http://postgis.refractions.net/mailman/listinfo/postgis-users



-- 


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] Postgis 1.5 core dumps on GEOSIntersects with side location conflict

2012-09-20 Thread Adam
Thx I was wondering how we could fix existing geometries.
 ST_SimplifyPreserveTopology did a nice job on the one I mentioned in the
email.
Still would like Postgis1.5 not to core dump on this condition though...

On Thu, Sep 20, 2012 at 11:04 AM, Dave Potts dave.po...@pinan.co.uk wrote:

 I have used the jts library and have the same type of issue

 In jts you would

 1.  Try to use a buffer of 0.
 2.  Try calling one of the simplify geom operations.

 Dave.
 Adam wrote:
  Running this query against Postgis 1.5 causes a core dump:
  SELECT ST_intersects(
 geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
  67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
  67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326),
 geomfromtext('POLYGON((31.904296875 67.32421875,14.58984375
  67.32421875,12.744140625 65.830078125,33.75 66.09375,31.904296875
  67.236328125,31.81640625 67.32421875,31.904296875 67.32421875))', 4326)
  );
 
  Running against Postgis 2.0 gives the following error (much preferred to
  get an error than a core dump!):
  ERROR:  GEOSIntersects: TopologyException: side location conflict at
  31.81640625 67.32421875
  CONTEXT:  SQL function st_intersects statement 1
 
  Both are using geos version: '3.3.5-CAPI-1.7.5'.
 
  Unfortunately upgrading to Postgis 2 is not an option for us.
  Our platform is Solaris 10 x86 using 64 bit builds.
 
 From dbx the core file shows:
[1] 0x1b408d(0x1, 0x1, 0x474e5543432b2b00, 0xbe0170,
 0xfd7fffdf8880,
  0x1b408d), at 0x1b408d
[2] _Unwind_RaiseException_Body(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
  0xfd7ffec416bc
[3] _SUNW_Unwind_RaiseException(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at
  0xfd7ffec418a9
[4] __cxa_throw(obj = (nil), tinfo = (nil), dest = (nil)), line 75 in
  eh_throw.cc
[5] geos::geomgraph::EdgeEndStar::propagateSideLabels(this =
  0xfd7ffe6e2a00, geomIndex = 0), line 69 in new_allocator.h
[6]
 
 _ZN4geos9geomgraph11EdgeEndStar16computeLabellingEPSt6vectorIPNS0_13GeometryGraphESaIS4_EE(this
  = 0x91bc10, geomGraph = 0xfd7fffdf8e18), line 88 in EdgeEndStar.cpp
[7] geos::operation::relate::RelateComputer::labelNodeEdges(this =
  0xfd7fffdf8e30), line 327 in RelateComputer.cpp
[8] geos::operation::relate::RelateComputer::computeIM(this =
  0xfd7fffdf8e30), line 131 in RelateComputer.cpp
[9] geos::operation::relate::RelateOp::relate(a = (nil), b = (nil)),
  line
  43 in RelateOp.cpp
[10] geos::geom::Geometry::intersects(this = 0x91b598, g = 0x91b638),
  line 191 in memory
[11] GEOSIntersects_r(extHandle = 0x91d100, g1 = (nil), g2 = (nil)),
  line
  351 in geos_ts_c.cpp
[12] GEOSIntersects(g1 = (nil), g2 = (nil)), line 139 in geos_c.cpp
[13] intersects(fcinfo = 0xfd7fffdf9110), line 2322 in
  lwgeom_geos.c
[14] ExecMakeFunctionResult(fcache = 0xfd7fffdf90d0, econtext =
  0xbd5740, isNull = 0xbd6c28 , isDone = (nil)), at 0x5a9d88
[15] ExecEvalAnd(andExpr = (nil), econtext = 0xbd5740, isNull =
 0xbd6c28
  , isDone = (nil)), at 0x5aaf23
[16] ExecProject(projInfo = 0xbd6c40, isDone = 0xfd7fffdf95bc), at
  0x5ae659
[17] ExecResult(node = 0xbd5630), at 0x5ba7d0
[18] ExecProcNode(node = 0xbd5630), at 0x5a77ec
[19] standard_ExecutorRun(queryDesc = 0xbcd2e8, direction =
  ForwardScanDirection, count = 1), at 0x5a550c
[20] fmgr_sql(fcinfo = 0xfd7fffdf9880), at 0x5b1529
  ___
  postgis-users mailing list
  postgis-users@postgis.refractions.net
  http://postgis.refractions.net/mailman/listinfo/postgis-users
 


 --


 ___
 postgis-users mailing list
 postgis-users@postgis.refractions.net
 http://postgis.refractions.net/mailman/listinfo/postgis-users

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[postgis-users] PostGIS 1.5

2010-05-25 Thread eehab hamzeh

Hello 

I try to restore a database was created and backed-up in PostGIS 1.3.5 to 
PostGIS 1.5 
the geometry cant be restored any hint please how to deal with the problem.

Where i can find PostGIS 1.3.5 windows binaries.

Kind regards


  
_
Hotmail: Powerful Free email with security by Microsoft.
https://signup.live.com/signup.aspx?id=60969___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


Re: [postgis-users] PostGIS 1.5

2010-05-25 Thread Thomas Gratier
Hello,

Look depending of postgresql installation into
http://postgis.refractions.net/download/windows/pg82/
http://postgis.refractions.net/download/windows/pg83/
http://postgis.refractions.net/download/windows/pg84/

For upgrading database, go to
http://wiki.debian.org/DebianGis/UpdatingPostGIS for some advices

Regards

ThomasG
GIS specialist
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users