[fdo-trac] #443: PostGIS defect : Only 1 geometry column of a table
can be used
FDO
trac_fdo at osgeo.org
Thu Dec 11 14:58:18 EST 2008
#443: PostGIS defect : Only 1 geometry column of a table can be used
--------------------------------+-------------------------------------------
Reporter: mwtoews | Owner: mloskot
Type: defect | Status: new
Priority: major | Milestone: 3.4.0
Component: PostGIS Provider | Version: 3.2.0
Severity: 3 | Keywords:
External_id: |
--------------------------------+-------------------------------------------
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).
--
Ticket URL: <http://trac.osgeo.org/fdo/ticket/443>
FDO <http://fdo.osgeo.org/>
Feature Data Objects
More information about the fdo-trac
mailing list