Re: Error when inserting data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: postgresql(at)thomasbache(dot)de
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error when inserting data
Date: 2005-03-05 16:14:24
Message-ID: 17492.1110039264@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

postgresql(at)thomasbache(dot)de writes:
> ERROR: 22003: integer out of range
> LOCATION: int84, int8.c:947

So this is complaining about something that was initially an int8,
which is to say none of the stuff you've shown us, except possibly
the serial column (could the serial counter have exceeded 2^31?).

> The interesting part of the table-definition is

I think the problem is probably buried in something you didn't
show us, eg a default for one of the other columns.

regards, tom lane

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message postgresql 2005-03-05 17:33:52 Re: Error when inserting data
Previous Message postgresql 2005-03-05 15:35:25 Error when inserting data