[postgis-users] Columnname GEOMETRY

[Uwe Dalluege]

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