<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=FR link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>The following query
(negative buffer) stop my current postgreSQL connection and rollback the other
connections:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>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);<o:p></o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:double windowtext 2.25pt;
padding:0cm 0cm 1.0pt 0cm'>
<p class=MsoNormal style='border:none;padding:0cm'><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>The message is the
following :<o:p></o:p></span></font></p>
<p class=MsoNormal><i><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black;font-style:italic'>server
closed the connection unexpectedly<o:p></o:p></span></font></i></p>
<p class=MsoNormal><i><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black;font-style:italic'>
This probably means the server terminated abnormally<o:p></o:p></span></font></i></p>
<p class=MsoNormal><i><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black;font-style:italic'>
before or while processing the request.<o:p></o:p></span></font></i></p>
<p class=MsoNormal><i><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black;font-style:italic'>The
connection to the server was lost. Attempting reset: Failed.<o:p></o:p></span></font></i></p>
<div style='mso-element:para-border-div;border:none;border-bottom:double windowtext 2.25pt;
padding:0cm 0cm 1.0pt 0cm'>
<p class=MsoNormal style='border:none;padding:0cm'><i><font size=2 color=black
face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;
color:black;font-style:italic'>!><o:p></o:p></span></font></i></p>
</div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Therefore the
multipolygon is valid (function isvalid).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>If I try buffer on the 2
polygons separately, it works. One result is empty polygon.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Is there a problem with this
object, with my installation, with my query or negative buffer? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Best<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>Olivier<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:black'>PS: I’m using
postgreSQL 8.3.7, Postgis 1.3.4 et geos 3.0.3 <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>