Ticket #120 (closed defect: wontfix)

Opened 4 years ago

Last modified 16 months ago

PostGIS ungracefully handles structural problems in a database

Reported by: mloskot Owned by:
Priority: major Milestone: 3.4.0
Component: PostGIS Provider Version: 3.2.0
Severity: 3 Keywords:
Cc: External ID:

Description

Robert Bray reported he got error like this one, in the fdopostgis log file:

ERROR:  LWGEOM_estimated_extent: permission denied for relation delme

After some tests, he followed up with following post:

Ah, I think I found the problem. The delme table has an entry in the geometry_columns table for a column named geometry, however that column does not actually exist in the delme table. So the problem appears to be a structural problem in the DB. The provider bombs quite ungracefully on this condition, which is something we might want to look at.

Summarizing, this kind of issues should be investigated and fixed, so an exception is thrown instead of a bomb.

Change History

Changed 4 years ago by gregboone

  • milestone changed from 3.3.0 to 3.3.1

Changed 3 years ago by mloskot

  • owner mloskot deleted

Changed 16 months ago by gregboone

  • status changed from new to closed
  • resolution set to wontfix

Further PostGIS Provider development has been routed to the PostgreSQL Provider. Advise using that provider.

Note: See TracTickets for help on using tickets.