Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

ST_GeomFromGeoJSON()

Hi, during COPY this function returns an error if the polygon is invalid.
We want to insert the row even if an error occur. that is, to insert a null instead of the polygon.
What can we do in order to solve the problem?
We tried to wrap this function with user-defined function but we didn't find an option to catch the exception.

Thank you !

Answers

  • Ariel_CaryAriel_Cary Employee

    There is no workaround to that problem right now. But we do understand it can be useful to optionally have ST_GeomFromGeoJSON return null on failure. We're considering adding such option in future releases.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.