<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Gissur,</span></div><div><br><span></span></div><div>As the PostgreSQL documentation says: <code class="function">pg_get_serial_sequence</code> returns the name of the
sequence associated with a column, or NULL if no sequence is associated with the
column.</div><div><br></div><div>So, I suggest a patch for TinyOWS to check for this when<span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> --check</span> parameter is issued to ensure that all the layers have a sequence tied with a serial/bigserial column, this includes the <code class="literal">OWNED BY NONE </code>case. </div><div><br></div><div>Cheers from México<br></div><div><br></div><div><font style="font-weight:bold;color:rgb(0, 96, 191);font-family:verdana, helvetica, sans-serif;" size="2">IC Carlos Ruiz</font><br><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Gissur Þórhallsson <gissur@loftmyndir.is><br><b><span style="font-weight: bold;">To:</span></b> TinyOWS users discuss list
<tinyows-users@lists.maptools.org><br><b><span style="font-weight: bold;">Sent:</span></b> Wednesday, September 28, 2011 6:01 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [TinyOWS-users] value out of range for type integer<br></font><br><meta http-equiv="x-dns-prefetch-control" content="off"><div id="yiv1178106314">Hi, <br><br>I have an update and fix for my issue - my workaround was keeping me from opening the table in qgis (as postgis connection not WFS) due to the data type of the primary key (bigint) so I decided to give fixing it the old college try.<br>
<br>After upgrading to 1.0.0rc4 and setting LOG_LEVEL to SQL I noticed that tinyows was calling the postgresql function <b style="font-family:courier new, monospace;">pg_get_serial_sequence</b> and getting a null result.<br>
<br>This was due to some table juggling hanky panky I'd pulled while updating the data which left the sequence in the ownership by an older table which I'd replaced by renaming it and sticking the update in it's place (a terrible practice, I realize).<br>
<br>I had the sequence specified as the DEFAULT value for the column, but <b style="font-family:courier new, monospace;">pg_get_serial_sequence</b> acutally returns sequences<b> <span style="font-family:courier new, monospace;">OWNED BY</span></b> table.column which was not the case.<br>
<br>This caused tinyOWS to 'helpfully' fabricate huge numbers for the primary key.<br><br>Anyway, after a simple<b style="font-family:courier new, monospace;"><br> ALTER SEQUENCE "my_table_gid_seq" OWNED BY my_table.gid;<br>
</b>command, all fell into place. <br><br>I'm not sure whether this is bug or not, but perhaps it should be more natural for tinyOWS to return an error if the following is true:<br><ul><li>Column has a NOT NULL constraint</li>
<li>No sequence can be found for said column<br></li><li>No value was provided</li></ul>Fabricating values in the face of these conditions seems unwise.<br><br>But I might be missing something.<br><br>Anyway, just thought I'd throw this out there in case anybody ever stumbles onto this thread with a similar issue.<br>
<br>Kind regards from Iceland,<br>Gissur<br><br><div class="yiv1178106314gmail_quote">2011/8/24 Gissur Þórhallsson <span dir="ltr"><<a rel="nofollow" ymailto="mailto:gissur@loftmyndir.is" target="_blank" href="mailto:gissur@loftmyndir.is">gissur@loftmyndir.is</a>></span><br><blockquote class="yiv1178106314gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
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><font color="#888888">Gissur</font><div><div></div><div class="yiv1178106314h5"><br><br><br><br><div class="yiv1178106314gmail_quote">On Thu, Aug 4, 2011 at 11:07 AM, Olivier Courtin <span dir="ltr"><<a rel="nofollow" ymailto="mailto:olivier.courtin@gmail.com" target="_blank" href="mailto:olivier.courtin@gmail.com">olivier.courtin@gmail.com</a>></span> wrote:<br>
<blockquote class="yiv1178106314gmail_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><br>
--<br>
Olivier<br>
_______________________________________________<br>
TinyOWS-users mailing list<br>
<a rel="nofollow" ymailto="mailto:TinyOWS-users@lists.maptools.org" target="_blank" href="mailto:TinyOWS-users@lists.maptools.org">TinyOWS-users@lists.maptools.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.maptools.org/mailman/listinfo/tinyows-users">http://lists.maptools.org/mailman/listinfo/tinyows-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><div><div></div><div class="yiv1178106314h5">-- <br>Gissur Þórhallsson<br><br>Loftmyndir ehf.<br>Laugavegur 13<br>IS 101 Reykjavík - Iceland<br>sími (tel): <a rel="nofollow">(+354) 540 2500</a><br>
tölvupóstur (email): <a rel="nofollow" ymailto="mailto:gissur@loftmyndir.is" target="_blank" href="mailto:gissur@loftmyndir.is">gissur@loftmyndir.is</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 rel="nofollow" ymailto="mailto:gissur@loftmyndir.is" target="_blank" href="mailto:gissur@loftmyndir.is">gissur@loftmyndir.is</a><br>
</div><meta http-equiv="x-dns-prefetch-control" content="on"><br>_______________________________________________<br>TinyOWS-users mailing list<br><a ymailto="mailto:TinyOWS-users@lists.maptools.org" 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><br><br></div></div></div></body></html>