Skip to main content
Geographic Information Systems

Return to Question

added 76 characters in body
Source Link
MinionAttack
MinionAttack
  • 113
  • 5

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),
.....

I get:

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?

Edit:

I'm using a legacy system whith PostgreSQL 8.4 and PostGIS 1.5

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),
.....

I get:

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 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),
.....

I get:

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?

Edit:

I'm using a legacy system whith PostgreSQL 8.4 and PostGIS 1.5

removed closing
Source Link
Vince
Vince
  • 20.3k
  • 16
  • 48
  • 65

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),
.....

I get:

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?

Regards.

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),
.....

I get:

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?

Regards.

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),
.....

I get:

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?

Source Link
MinionAttack
MinionAttack
  • 113
  • 5

PostgreSQL geometry type invalid

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),
.....

I get:

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?

Regards.