Ask Your Question

Loading geometry in Base causes hanging, crash [closed]

asked 2017-08-01 23:44:09 +0100

DPSSpatial gravatar image


We use LibreOffice Base as an interface to our PostgreSQL database, which with the PostGIS extension, enables the geometry data type.

When opening a table with geometry, especially polygon data, Base will hang loading the geometry column, and eventually hang.

Is there a way to avoid this, or is this something I should suggest as a bug?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-12 19:26:27.030209

1 Answer

Sort by » oldest newest most voted

answered 2017-08-10 00:17:11 +0100

Ratslinger gravatar image

updated 2017-08-10 00:32:27 +0100

Sorry for the extra long delay in answering. Haven't worked with such since MapInfo 15+ years ago. Have been meaning to it anyway, so I set it up.


Linux Mint 18 KDE
PostgreSQL 9.6.3
PostGIS 2.3.3
QGIS 2.14

Simple table :

CREATE TABLE public.branches
  branchid integer NOT NULL DEFAULT nextval('branches_branchid_seq'::regclass),
  branchname character varying(50),
  geom geometry(Polygon,4326),
  CONSTRAINT branches_pkey PRIMARY KEY (branchid)

Then used QGIS to create some polygons. Saved. Created Base file using PostgreSQL DB. Used Wizard to create form. Opened form without problem.

One item I don't quite understand yet is the way the polygon field is defined in the Base table:

image description

It comes up as a Memo [ text ] field. I was expecting Memo [ polygon ]. This may have something to do with your problem.


Of note, and almost forgot, using SDBC connector NOT JDBC. Could also have some bearing.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-08-01 23:44:09 +0100

Seen: 139 times

Last updated: Aug 10 '17