[TinyOWS-users] value out of range for type integer

Gissur Þórhallsson gissur at loftmyndir.is
Wed Aug 24 05:15:14 EST 2011

Hi Olivier,

(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 :)

Kind regards,

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;
> HTH,
> --
> Olivier
> _______________________________________________
> TinyOWS-users mailing list
> TinyOWS-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-users

Gissur Þórhallsson

Loftmyndir ehf.
Laugavegur 13
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...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20110824/3d14f1d9/attachment.htm 

More information about the TinyOWS-users mailing list