I'm trying to create some tables on PostgreSQL with a Geometry field. For the Polygon and Point types it works but when I want to create a Line o LSEG type I get an error.
If I do:
..... geometry_field geometry(Polygon, 25829), or geometry_field geometry(Point, 25829), .....
it works and the table it's created but when I try:
..... geometry_field geometry(Line, 25829), or geometry_field geometry(LSEG, 25829), .....
ERROR: Invalid geometry type modifier: line or lseg
Looking at the Documentation the type exists so I don't know what I'm doing wrong.
Where is my mistake?
I'm using a legacy system whith PostgreSQL 8.4 and PostGIS 1.5