2

I am attempting to insert rows into a spatial table within a geopackage file using DBeaver 5.1.1.

I receive an error from the triggers, referencing functions that don't exist: ST_IsEmpty. Do I need to load these functions via a similar means to the spatialite load_extension? And does a library extension exist for geopackages?

SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (no such function: ST_IsEmpty)
  [SQLITE_ERROR] SQL error or missing database (no such function: ST_IsEmpty)
  [SQLITE_ERROR] SQL error or missing database (no such function: ST_IsEmpty)

1 Answer 1

1

I sort of answered my own question in the question. I issued a
SELECT load_extension('mod_spatialite.dll'); statement (files are already in my path). And I was able insert my rows. While it works, there may be a more correct way to do it? Like using a geopackage specific extension?

Also for DBeaver, I had to enable_load_extension on the driver properties.
enter image description here

3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.