[postgis-users] negative buffer

[Paul Ramsey]

No problems here, perhaps try upgrading to GEOS 3.2

P

On Tue, Jan 5, 2010 at 9:37 AM, olivier dorie <olivier.dorie at ign.fr> wrote:
> Hi all,
>
>
>
> The following query (negative buffer) stop my current postgreSQL connection
> and rollback the other connections:
>
>
>
> select buffer(geomfromtext('MULTIPOLYGON(((410397.744442313
> 6274725.08312074,410396.9 6274728.9,410393.2 6274737.5,410386.7
> 6274747.5,410376.5 6274759.7,410368.5 6274770.4,410361.2 6274781,410354.6
> 6274801.5,410354.5 6274815.3,410355.4 6274824.4,410357.3 6274834.8,410360.1
> 6274843.9,410368 6274859.8,410372 6274865.6,410385.4 6274880.6,410389.4
> 6274886.4,410394.6 6274895.1,410400.7 6274902.2,410408 6274908.3,410416.3
> 6274912.1,410423.9 6274911.8,410432.5 6274910.3,410440.3 6274911.1,410449.4
> 6274911.8,410460.5 6274910.7,410468.9 6274909,410478.1 6274908.1,410487.6
> 6274907.7,410495 6274905.7,410503.3 6274902.9,410512.5 6274899.9,410522.3
> 6274893.9,410529.3 6274888.3,410533.7 6274881.4,410537 6274871.1,410539
> 6274857.7,410540.8 6274846.7,410544.3 6274832.9,410547.8 6274822.8,410554.4
> 6274809.9,410559.4 6274799.7,410565.7 6274785.2,410570 6274772.3,410574
> 6274759.1,410578.5 6274751.9,410583.8 6274746.2,410594 6274741.2,410602.6
> 6274737.7,410610.2 6274733.8,410617 6274729.3,410624.5 6274722.2,410630
> 6274713.1,410633.1 6274700.9,410634 6274690.3,410633.7 6274679.4,410631.2
> 6274670.3,410627.3 6274664.7,410621 6274658.7,410616.8 6274652.8,410611.8
> 6274642.2,410607 6274625.3,410605.7 6274615.8,410605.6 6274608.6,410607.1
> 6274601.2,410609.8 6274593.5,410614.1 6274582.6,410617.6 6274573.2,410621
> 6274565.2,410624.3 6274560.4,410628.7 6274556.7,410633.4 6274554.1,410639.5
> 6274551.3,410646.3 6274549,410653.5 6274547.4,410660.1 6274546.8,410666.4
> 6274547.5,410682.1 6274552.7,410697.7 6274561.1,410705.4 6274565.6,410714.6
> 6274570.3,410736.4 6274578.5,410767.8 6274588.7,410792 6274600.5,410815.7
> 6274608.1,410831.7 6274612.3,410840.3 6274613,410852.2 6274612.7,410861
> 6274610.6,410869.8 6274605.9,410878.5 6274598.9,410884.7 6274594.9,410892.1
> 6274592.2,410898.4 6274590.1,410906.1 6274587.8,410912.2 6274586.1,410918.9
> 6274584.1,410925.4 6274583.4,410930.1 6274583.7,410939.8 6274583.6,410946.4
> 6274583.2,410952.1 6274581.5,410957.5 6274578.6,410963.5 6274573.5,410968.6
> 6274567.2,410976.4 6274558.7,410984.3 6274552,410989.5 6274549,410992.6
> 6274513.4,410986.699538985 6274495.74400512,410991.4 6274515,410916.6
> 6274530.6,410837.1 6274581.2,410822.1 6274581.3,410787.1 6274572.6,410715.9
> 6274538.2,410670.8 6274528.6,410631 6274543.9,410596.4 6274584.2,410592
> 6274664.1,410548.7 6274739.4,410514.6 6274844.6,410489.8 6274870.7,410455
> 6274886,410410.1 6274891.4,410395 6274881.5,410373.8 6274846.7,410373.4
> 6274806.8,410397.9 6274740.6,410397.744442313 6274725.08312074)),((410213.2
> 6274758.1,410235.4 6274718.7,410236.2 6274713.3,410239.3 6274701,410246.8
> 6274691.1,410251.7 6274684.6,410256.4 6274676.6,410260.6 6274667.3,410263.3
> 6274657.3,410263.9 6274645.6,410264.4 6274636.1,410266.2 6274628.1,410270.2
> 6274621.4,410275.4 6274617.3,410280.2 6274614.9,410286.4 6274614.6,410300.8
> 6274617.9,410309.5 6274619,410319.4 6274621.5,410328.7 6274624.8,410339.4
> 6274633.2,410345 6274640.4,410352.8 6274650.1,410361.7 6274660.9,410369
> 6274668.7,410378.3 6274678.4,410382.6 6274682.6,410388.6 6274687.9,410392.9
> 6274693.8,410396.2 6274702.2,410397.563140393 6274706.99825418,410397.5
> 6274700.7,410382.3 6274665.8,410347 6274631.2,410291.8 6274591.7,410276.7
> 6274586.8,410242.2 6274633,410217.6 6274688.2,410213.2
> 6274758.1)))',-1),-25);
>
>
>
> The message is the following :
>
> server closed the connection unexpectedly
>
>         This probably means the server terminated abnormally
>
>         before or while processing the request.
>
> The connection to the server was lost. Attempting reset: Failed.
>
> !>
>
>
>
> Therefore the multipolygon is valid (function isvalid).
>
>
>
> If I try buffer on the 2 polygons separately, it works. One result is empty
> polygon.
>
>
>
> Is there a problem with this object, with my installation, with my query or
> negative buffer?
>
>
>
> Best
>
>
>
> Olivier
>
>
>
> PS: I’m using postgreSQL 8.3.7, Postgis 1.3.4 et geos 3.0.3
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>