Ask Your Question
0

Loading geometry in Base causes hanging, crash

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

DPSSpatial gravatar image

All,

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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.

Used:

Linux Mint 18 KDE
LO 5.1.6.2
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)
)
WITH (
  OIDS=FALSE
);

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.

EDIT:

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 94 times

Last updated: Aug 10 '17