Re: [JPP-Devel] Extent calculation

2013-04-02 Thread Uwe Dalluege
Hi Michaël, Am 02.04.2013 20:40, schrieb Michaël Michaud: > Hi Uwe, >> I made a small test and I can >> always reproduce an error. >> I think it is better to make more >> tests *after* you find this bug: >> >> 1. Run this in pgAdminIII (without creating indices!): >> >> drop table if exists t_line

Re: [JPP-Devel] Extent calculation

2013-04-02 Thread Michaël Michaud
Hi Uwe, > I made a small test and I can > always reproduce an error. > I think it is better to make more > tests *after* you find this bug: > > 1. Run this in pgAdminIII (without creating indices!): > > drop table if exists t_line_invis; > CREATE TABLE t_line_invis ( lnr integer, geom geometry ( LI

Re: [JPP-Devel] Extent calculation

2013-04-02 Thread Uwe Dalluege
Hi Michaël, I made a small test and I can always reproduce an error. I think it is better to make more tests *after* you find this bug: 1. Run this in pgAdminIII (without creating indices!): drop table if exists t_line_invis; CREATE TABLE t_line_invis ( lnr integer, geom geometry ( LINESTRING,

Re: [JPP-Devel] Extent calculation

2013-03-31 Thread Michaël Michaud
Hi Uwe, I made two improvements to try to solve the extent calculation problem (see r3439). Note : I don't know if you still have the WKB 0 bug. Add a "VACUMM ANALYZE theNewTable" after creation of a new table why ? It seems that the index creation is not enough to use ST_Estimated_Extent just a