Received: from dust.hpcc.nectec.or.th (root@dust.hpcc.nectec.or.th [164.115.24.238]) by hub.org (8.9.1/8.9.1) with ESMTP id UAA29527 for ; Wed, 13 Jan 1999 20:01:23 -0500 (EST) (envelope-from chat@hpcc.nectec.or.th) Received: from TIWRM1.hpcc.nectec.or.th (tiwrm1.hpcc.nectec.or.th [164.115.24.206]) by dust.hpcc.nectec.or.th (8.7.5/8.7.3) with SMTP id HAA18364 for ; Thu, 14 Jan 1999 07:59:52 +0700 Message-ID: <001e01be3f59$2b62ff60$ce1873a4@TIWRM1.hpcc.nectec.or.th> From: "Chatchawan Boonraksa" To: Subject: Geometry filed type Date: Thu, 14 Jan 1999 07:59:42 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01BE3F93.D7865500" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.2201.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2201.0 This is a multi-part message in MIME format. ------=_NextPart_000_001B_01BE3F93.D7865500 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable 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?=20 TIA,=20 chat ------=_NextPart_000_001B_01BE3F93.D7865500 Content-Type: text/html; charset="windows-874" Content-Transfer-Encoding: quoted-printable
Hi all,
 
I'm new user of = PostgreSQL. Currently=20 I have PostgreSQL 6.4.2 installed.
 
I have some question on = the limit of=20 geomerty field type, e.g. polygon, lseg, ...
 
I have create a table = with 'polygon=20 field' and tried to insert data into each record
and got an error on = exceed 8191 bytes=20 limitation. I'm using both 'psql' and 'php'
and get the same error. = My data will=20 be sequence of coordinate in UTM which
some=20 larger than 8k on average.
 
Is there be a way to insert a field = which larger=20 than 8k size into postgres?
If so, is there also a way to get it = out in a=20 not-too-hard way?
 
TIA,
chat
 
------=_NextPart_000_001B_01BE3F93.D7865500--