Opened 17 years ago

Closed 14 years ago

#120 closed defect (wontfix)

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 (3)

comment:1 by gregboone, 17 years ago

Milestone: 3.3.03.3.1

comment:2 by mloskot, 16 years ago

Owner: mloskot removed

comment:3 by gregboone, 14 years ago

Resolution: wontfix
Status: newclosed

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

Note: See TracTickets for help on using tickets.