PostGIS defect : Only 1 geometry column of a table can be used

[Mike Toews]

I have a table that defines two geometry columns for georeferenced and unreferenced site-plan coordinates:

CREATE TABLE fdb.area(
  gid serial NOT NULL,
  unref geometry, -- SELECT AddGeometryColumn('fdb','area','unref',-1,'POLYGON',2)
  georef geometry, -- SELECT AddGeometryColumn('fdb','area','georef',4326,'POLYGON',2)
  ...

and I've add this into geometry_columns:

 f_table_catalog | f_table_schema | f_table_name | f_geometry_column | coord_dimension | srid |  type   
-----------------+----------------+--------------+-------------------+-----------------+------+---------
                 | fdo            | area         | georef            |               2 | 4326 | POLYGON
                 | fdo            | area         | unref             |               2 |   -1 | POLYGON
(2 rows)

However, when I try to pull the data up in AutoCAD Map 3D 2008, I only see one "area" with SRID -1, and I don't see both combinations (as I do with QGIS).

[Mike Toews]

(the "fdb" vs "fdo" schema naming confusion in the above example is irrelevant to the to this ticket ... they are just typos that I missed before submitting)

[gregboone]

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