<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:10pt"><div style="font-family: arial,helvetica,sans-serif;"><span>Olivier,</span></div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">As you know, I haven't had no much time to help TinyOWS because my work and my master, but this week I had some time and I started to implement the WFS transaction locks.<br></div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">I'm using the PostGIS functions such as <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">EnableLongTransactions</span>, <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">AddAuth</span>, <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">LockRow</span>.
Currently I'm working with the <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">wfs_parse_operation</span> function within the <span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">wfs_transaction.c</span> file.<br></div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">I have some questions at this point:</div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">Does TinyOWS must abort the transaction if it cannot set locks on the transaction tables ?</div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">The PostGIS locking functions works at row level, I don't know if it's better to work at table level to avoid setting locks to every row specified in the WFS transaction, because right now TinyOWS must
lock row by row with a SELECT LockRow(...) statement.<br></div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">What do you think ?<br></div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">I have advanced too much with this and I hope to send you the patch soon.</div><div style="font-family: arial,helvetica,sans-serif;"><br></div><div style="font-family: arial,helvetica,sans-serif;">P.S. I'm working with the 614 revision.<br></div><div style="font-family: arial,helvetica,sans-serif;"><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></div></div></body></html>