Don't understand error?

From: James David Smith <james(dot)david(dot)smith(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Don't understand error?
Date: 2014-04-14 08:46:41
Message-ID: CAMu32ACDD1p=by0xoFiP=wgEa7wECAcHfbQyBY6X3rbEWm=cXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi everyone,

I'm working with a large spatial dataset at the moment. About 109m
rows. What I do is join some other tables to it, do some maths and
spatial joins, and then put the results into a new table (which is
therefore 109m rows too).

When I run my SQL for 50 people it's fine. 1 person is fine. A
thousand people it's fine. But when I try and run it for the whole
dataset I'm given this error:

ERROR: value out of range: underflow
****************Error *******************
Error: Value out of range: underflow
SQL state: 22003

I've looked this up, but I don't really get what it is saying. I'd
appreciate some advice? I was going to post my actual SQL code but
it's about 150 lines long and I wasn't sure it would be useful.

Thanks

James

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2014-04-14 13:58:35 Re: Don't understand error?
Previous Message Brent Dombrowski 2014-04-11 14:29:07 Re: Variables inside PostgreSQL/PostGIS query in PHP file