[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Database restarting while using  ST Functions
From:       "Pradeep Kanth G" <pgundala () avineonindia ! com>
Date:       2018-02-06 11:11:47
Message-ID: 00ad01d39f39$9a824fe0$cf86efa0$ () avineonindia ! com
[Download RAW message or body]

This is a multipart message in MIME format.

[Attachment #2 (multipart/related)]
This is a multipart message in MIME format.

[Attachment #4 (multipart/alternative)]


Dear All,

 

Kindly raise the below issue with EDB.

 

Observation :  Database restarting while using  ST Functions.

Issue :   Intersecting with two geometries, while using ST_Intersects and
ST_CollectionHomogenize functions

Database is restarting automatically.

Example: ST_Intersects(ST_CollectionHomogenize(p.geometry,c.geometry))

Screenshot:



 

 

Regards

Pradeep Kanth

 



Disclaimer | The information contained in this electronic message (including any \
attachments) is intended for the exclusive use of the addressee(s) and may contain \
confidential or privileged information.If you have received this in error, please \
notify the sender immediately and delete the material from your machine. Any action \
including review, retransmission, dissemination of this email or the attachments \
present along with the email by persons or entities other than the intended recipient \
is prohibited.


[Attachment #7 (text/html)]

<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
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 15 \
(filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);} o\:* \
{behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
	{mso-style-name:msonormal;
	mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;}
span.EmailStyle18
	{mso-style-type:personal;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" \
vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Dear All,<o:p></o:p></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>Kindly raise the below issue \
with EDB.<o:p></o:p></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p \
class=MsoNormal><b>Observation</b> : &nbsp;Database restarting while using &nbsp;ST \
Functions.<o:p></o:p></p><p class=MsoNormal><b>Issue</b> : &nbsp;&nbsp;Intersecting \
with two geometries, while using ST_Intersects and ST_CollectionHomogenize \
functions<o:p></o:p></p><p class=MsoNormal style='text-indent:.5in'>Database is \
restarting automatically.<o:p></o:p></p><p class=MsoNormal><b>Example</b>: \
ST_Intersects(ST_CollectionHomogenize(p.geometry,c.geometry))<o:p></o:p></p><p \
class=MsoNormal><b>Screenshot:<o:p></o:p></b></p><p class=MsoNormal><img width=384 \
height=169 style='width:4.0in;height:1.7604in' id="Picture_x0020_1" \
src="cid:image001.png@01D39F67.B40DAF80"><b><o:p></o:p></b></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal \
style='text-indent:.5in'><o:p>&nbsp;</o:p></p><p class=MsoNormal><span \
style='color:black'>Regards<o:p></o:p></span></p><p class=MsoNormal><span \
style='color:black'>Pradeep Kanth<o:p></o:p></span></p><p \
class=MsoNormal><o:p>&nbsp;</o:p></p></div><BR /> <BR />
<div align="left"><b>Disclaimer </b>| The information contained in this electronic \
message (including any attachments) is intended for the exclusive use of the \
addressee(s) and may contain confidential or privileged information.If you have \
received this in error, please notify the sender immediately and delete the material \
from your machine. Any&nbsp; action including review, retransmission, dissemination \
of this email or the attachments present along with the email by persons or entities \
other than the intended recipient is prohibited.<br></div><br><br><BR /> \
</body></html>


["image001.png" (image/png)]
[Attachment #9 (text/plain)]

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic