[postgis-users] Quick/unobstrusive way to determine if a geometry has curve elements?

Rémi Cura remi.cura at gmail.com
Tue May 5 02:53:24 PDT 2015

Putting an exception block will slow down your function.
You can put an exception in any plpgsql function.

So you only need the right to create a plpgsql function.


2015-05-05 11:45 GMT+02:00 Andrea Aime <andrea.aime at geo-solutions.it>:

> On Tue, May 5, 2015 at 11:35 AM, Nicolas Ribot <nicolas.ribot at gmail.com>
> wrote:
>> Hi Andrea,
>> You could use a PLPGSQL function to catch error for curved geometries and
>> return the geometry itself in case of error.
>> Then, either you put all your generic code in this function, or you just
>> write a wrapper around st_simplify and call it from your SQL code,
>> according to your needs.
> Yep, that's an idea... however it requires some level of admin rights on
> the database, which the applications based on GeoTools (uDig, GeoServer) do
> not
> normally get.
> It is possible to catch errors inline in a select statement?
> Cheers
> Andrea
> --
> ==
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/NWWaa2 for more information.
> ==
> Ing. Andrea Aime
> @geowolf
> Technical Lead
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39  339 8844549
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
> darcene notizia via e-mail e di procedere alla distruzione del messaggio
> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
> principi dettati dal D.Lgs. 196/2003.
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender
> does not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility  for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
> -------------------------------------------------------
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150505/ac8dd9a2/attachment.html>

More information about the postgis-users mailing list