Received: from smtp2.ihug.co.nz (tk2.ihug.co.nz [203.29.160.14]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA91376 for ; Mon, 13 Dec 1999 01:59:55 -0500 (EST) (envelope-from brent.wood@blazemail.com) Received: from blazemail.com (p56-max11.wlg.ihug.co.nz [209.78.48.56]) by smtp2.ihug.co.nz (8.9.3/8.9.3/Debian/GNU) with ESMTP id TAA24622 for ; Mon, 13 Dec 1999 19:59:49 +1300 Message-ID: <385493F8.D8D17B68@blazemail.com> Date: Mon, 13 Dec 1999 19:36:40 +1300 From: Brent Wood X-Mailer: Mozilla 4.6 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Problem copying polygon data into a table Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have an text file in the format: 800|((180.87575,-45.98757),(180.87868, -45.98798),...,(Xn,Yn)) to be read into a table of: attr type id int region polygon using the command copy from '' using delimiters '|'; The polygon has about 800 vertices (& is relatively small as some of the polygons in my dataset go). Trying to copy this into the table generates the error msg: ERROR: Tuple is too big: size 12892 Does this mean that I've done summat incorrect, or that there is an undocumented limit in what can be loaded in a "copy" command, or a limit in the size (not area) of a polygon attribute? The message gives me the impression that there is a limit in the length of the string representing the polygon, so I could possibly fit more vertices by reducing the precision of each, but it still implies a limit which may render PostgreSQL unsuitable for my purposes. Any advice appreciated.... Thanks, Brent