pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brent Wood <brent.wood@blazemail.com>
To: pgsql-sql@postgresql.org
Subject: Problem copying polygon data into a table
Date: Mon, 13 Dec 1999 19:36:40 +1300
Message-ID: <385493F8.D8D17B68@blazemail.com> (raw)


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 <table> from '<file>' 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




view thread (3+ messages)  latest in thread

Message-ID: <385493F8.D8D17B68@blazemail.com>
Permalink:  ../385493F8.D8D17B68@blazemail.com/
Also on:    postgresql.org/message-id/385493F8.D8D17B68@blazemail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: brent.wood@blazemail.com
  Subject: Re: Problem copying polygon data into a table
  In-Reply-To: <385493F8.D8D17B68@blazemail.com>
  References: <385493F8.D8D17B68@blazemail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox