Hi Olivier, <br><br>(Sorry for the late reply - been on holiday.)<br><br>Yeah - that works - except that it doesn't address the fact that tinyOWS shouldn't be inserting into the gid field at all.<br><br>I don't specify it anywhere and I have a sequence on the database side that's supposed to take care of it.<br>
<br>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).<br><br>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 :)<br>
<br>Kind regards, <br>Gissur<br><br><br><br><div class="gmail_quote">On Thu, Aug 4, 2011 at 11:07 AM, Olivier Courtin <span dir="ltr"><<a href="mailto:olivier.courtin@gmail.com">olivier.courtin@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Gissur,<br>
<br>
Pastebin works now for theses samples as i recheck now,<br>
<br>
Workaround could be simple as changing type in database from int to bigint<br>
Something like:<br>
<br>
ALTER TABLE jukka ALTER COLUMN column_name TYPE bigint;<br>
<br>
<br>
HTH,<br>
<div><div></div><div class="h5"><br>
--<br>
Olivier<br>
_______________________________________________<br>
TinyOWS-users mailing list<br>
<a href="mailto:TinyOWS-users@lists.maptools.org">TinyOWS-users@lists.maptools.org</a><br>
<a href="http://lists.maptools.org/mailman/listinfo/tinyows-users" target="_blank">http://lists.maptools.org/mailman/listinfo/tinyows-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Gissur Þórhallsson<br><br>Loftmyndir ehf.<br>Laugavegur 13<br>IS 101 Reykjavík - Iceland<br>sími (tel): (+354) 540 2500<br>tölvupóstur (email): <a href="mailto:gissur@loftmyndir.is">gissur@loftmyndir.is</a><br>