[postgis-devel] [PostGIS] #661: Type info of geography columns incomplete - pg_dump output wrong

PostGIS trac at osgeo.org
Wed Nov 17 01:56:35 PST 2010


#661: Type info of geography columns incomplete - pg_dump output wrong
-------------------------------+--------------------------------------------
 Reporter:  tider              |       Owner:  pramsey      
     Type:  defect             |      Status:  new          
 Priority:  medium             |   Milestone:  PostGIS 1.5.3
Component:  postgis            |     Version:  1.5.X        
 Keywords:  geography pg_dump  |  
-------------------------------+--------------------------------------------
 Steps to reproduce (using interactive psql):

 test=# CREATE table test (geom geography(GEOMETRY,4326));
 CREATE TABLE
 test=# \d test
          Table "public.test"
  Column |      Type       | Modifiers
 --------+-----------------+-----------
  geom   | geography(4326) |

 Note the wrong type "geography(4326)", it should be
 "geography(GEOMETRY,4326)". This type info is used by pg_dump as well,
 resulting in a failing CREATE TABLE statement.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/661>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list