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

[Bborie Park]

That would be because the schema "public" isn't in that user's
"search_path".  The following will show the current session's search_path.

SHOW search_path;

-bborie

On 09/20/2012 02:54 PM, Phil Hurvitz wrote:
> 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,
> 
> -P.
> 
> **************************************************************
> 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
> **************************************************************
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu