[postgis-users] Columnname GEOMETRY

[Abe Gillespie]

Are you sure the column name is "GEOMETRY" (uppercase) and not
"geometry" (lowercase)?  You have to take an extra step when creating
a table to make anything uppercase - by default Postgres forces
everything to lowercase.  It's a matter of:

CREATE TABLE foo
(
  "GEOMETRY" int4
)

instead of

CREATE TABLE foo
(
  GEOMETRY int4
)

-Abe

On 5/27/05, Uwe Dalluege <uwe.dalluege at rzcn.haw-hamburg.de> wrote:
> Hi,
> 
> I have a problem with the columnname "GEOMETRY".
> 
> When I do this:
> 
> create table point ( NR int4 );
> select AddGeometryColumn ( 'dbgeo', 'point', 'GEOMETRY', 0, 'POINT', 3 );
> insert into point ( nr, GEOMETRY ) values ( 100, GeometryFromText ( 'POINT
> ( 100.0 200.0 10.3 )', 0 ) );
> select * from point;
> 
> I receive the errormessage:
> ERROR:  column "geometry" of relation "point" does not exist
> 
> 
> But this works:
> 
> create table point ( NR int4 );
> select AddGeometryColumn ( 'dbgeo', 'point', 'geometry', 0, 'POINT', 3 );
> insert into point ( nr, geometry ) values ( 100, GeometryFromText ( 'POINT
> ( 100.0 200.0 10.3 )', 0 ) );
> select * from point;
> 
> 
> Is there a different between the columnname "GEOMETRY" and "geometry"?
> 
> Uwe
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>