Home > mailing lists

Geometry filed type - Mailing list pgsql-sql

From	Chatchawan Boonraksa
Subject	Geometry filed type
Date	January 13, 1999 23:01:24
Msg-id	001e01be3f59$2b62ff60$ce1873a4@TIWRM1.hpcc.nectec.or.th Whole thread Raw
List	pgsql-sql

Hi all,

I'm new user of PostgreSQL. Currently I have PostgreSQL 6.4.2 installed.

I have some question on the limit of geomerty field type, e.g. polygon, lseg, ...

I have create a table with 'polygon field' and tried to insert data into each record

and got an error on exceed 8191 bytes limitation. I'm using both 'psql' and 'php'

and get the same error. My data will be sequence of coordinate in UTM which

some larger than 8k on average.

Is there be a way to insert a field which larger than 8k size into postgres?

If so, is there also a way to get it out in a not-too-hard way?

TIA,

chat

From: "Jackson, DeJuan"
Date: 13 January 1999, 22:22:21
Subject: RE: [SQL] Sequences and Views

From: Charles Hornberger
Date: 13 January 1999, 23:24:45
Subject: very slow response time on large, multi-table view