[TinyOWS-users] value out of range for type integer
gissur at loftmyndir.is
Wed Aug 24 05:15:14 EST 2011
(Sorry for the late reply - been on holiday.)
Yeah - that works - except that it doesn't address the fact that tinyOWS
shouldn't be inserting into the gid field at all.
I don't specify it anywhere and I have a sequence on the database side
that's supposed to take care of it.
Also: this seems to happen when I mess around with the table I'm inserting
into (I had just restored from a backup when this suddenly popped up).
Even though changing the type to bigint does "fix" it - using 8 an byte
integer to store something that could easily be stored using 4 bytes just
really bugs me :)
On Thu, Aug 4, 2011 at 11:07 AM, Olivier Courtin
<olivier.courtin at gmail.com>wrote:
> Hi Gissur,
> Pastebin works now for theses samples as i recheck now,
> Workaround could be simple as changing type in database from int to bigint
> Something like:
> ALTER TABLE jukka ALTER COLUMN column_name TYPE bigint;
> TinyOWS-users mailing list
> TinyOWS-users at lists.maptools.org
IS 101 Reykjavík - Iceland
sími (tel): (+354) 540 2500
tölvupóstur (email): gissur at loftmyndir.is
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the TinyOWS-users