[Gdal-dev] OGR and PostGIS: Geometry type not reported

[Markus Neteler]

Hi,

it seems that the PG driver of OGR does not report the Geometry
type:

ogrinfo -summary PG:'host=localhost user=postgres dbname=vmap0' roadl_eurnasia
INFO: Open of `PG:host=localhost user=postgres dbname=vmap0'
using driver `PostgreSQL' successful.

Layer name: roadl_eurnasia
Geometry: Unknown (any)
Feature Count: 165714
Extent: (-28.819973, 30.000000) - (179.445129, 74.034302)
Layer SRS WKT:
GEOGCS["NAD83",
    DATUM["North_American_Datum_1983",
        SPHEROID["GRS 1980",6378137,298.257222101,
            AUTHORITY["EPSG","7019"]],
[...]

However, it's present in the table:
SELECT * from geometry_columns ;
f_table_catalog|f_table_schema|f_table_name|f_geometry_column|coord_dimension|srid|type|attrelid|varattnum|stats
|vmap0|polbnda_eurnasia|wkb_geometry|3|104306|POLYGON|425867661|2|
|vmap0|coastl_eurnasia|wkb_geometry|3|104306|LINESTRING|425875636|2|
|vmap0|watrcrsl_eurnasia|wkb_geometry|3|104306|LINESTRING|425882461|2|
[...]

I tried to find the problem, but I am no CPP programmer.

The bugtracker is still down, so I'm posting here.

Kind regards

 Markus Neteler