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
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 |