[postgis-users] field type "public.geometry"

Phil Hurvitz phurvitz at uw.edu
Thu Sep 20 14:54:24 PDT 2012

Hi, one of our users has some tables that show geometry fields as type 
"public.geometry," e.g.,

                   Column                  |       Type       | Modifiers
  ogc_fid                                  | integer          | not null
  the_geom                                 | public.geometry  |

whereas they used to have more "normal" types, e.g.,

                  Column            |          Type           | Modifiers
  ogc_fid                           | integer                 |
  the_geom                          | geometry(Geometry,2926) |

I don't know what might have caused this; the data in the field do not 
seem to have changed, but the field as it is has limited functionality. 
Can someone suggest a fix? Thanks,


Philip M. Hurvitz, PhD | Research Assistant Professor | UW-CBE
Urban Form Lab  | 1107 NE 45th Street, Suite 535  | Box 354802
University of Washington, Seattle, Washington  98195-4802, USA
phurvitz at u.washington.edu | http://gis.washington.edu/phurvitz
"What is essential is invisible to the eye." -de Saint-Exupéry

More information about the postgis-users mailing list