[postgis-users] Database restarting while using ST Functions

[Daniel Baston]

Hi Pradeep,

Try checking the output of "SELECT postgis_full_version()". If you're not
at the latest point-release, you should upgrade. There have been memory
handling bugs with ST_CollectionHomogenize that could maybe cause the issue
you're seeing.

Dan

On Tue, Feb 6, 2018 at 5:59 AM, Pradeep Kanth G <pgundala at avineonindia.com>
wrote:

> 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.
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180206/1a3958c8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 17296 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180206/1a3958c8/attachment.png>