Geometry filed type

From: "Chatchawan Boonraksa" <chat(at)hpcc(dot)nectec(dot)or(dot)th>
To: <pgsql-sql(at)postgreSQL(dot)org>
Subject: Geometry filed type
Date: 1999-01-14 00:59:42
Message-ID: 001e01be3f59$2b62ff60$ce1873a4@TIWRM1.hpcc.nectec.or.th
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Charles Hornberger 1999-01-14 01:23:40 very slow response time on large, multi-table view
Previous Message Jackson, DeJuan 1999-01-14 00:23:45 RE: [SQL] Sequences and Views