Hi,<br><br>Thanks, yes the warning was my fault, missing -nln option. The creation table error happens intermittently, could potentially caused by wrapping ogr2org execution from a C# thread. Any pointers/advices on how to make this call more reliable are much appreciated.<br>
<br>Thanks - H<br><br><div class="gmail_quote">On Fri, Oct 21, 2011 at 4:26 PM, <a href="/user/SendEmail.jtp?type=node&node=6920266&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a> [via OSGeo.org] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=6920266&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,
<br><br>I use the same ogr2ogr 1.8.1 running on both Windows 7 (64-bit) and XP. I got the expected result from Windows 7, but XP gave me warning and errors. The ogr2ogr command is:
<br><br>ogr2ogr.exe -f PostgreSQL "PG:dbname=name user=user password=pwd host=host_name port=5432" OCI:name/pwd@serviceID:table_name -overwrite -nlt POLYGON -nln new_table_name -sql "select * from table_name where column_n like '%somePattern%'"
<br><br>The XP warns of the conflict of using both -nln and -sql at the same time. It also issue error in creating the table.
<br><br>Why are there error/warning from XP version, and how can I fix it?
<br><br>Thanks - H
<br>
<br>
<hr color="#cccccc" noshade size="1">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1803224.n2.nabble.com/ogr2ogr-different-behaviour-on-different-OS-platforms-Windows-7-vs-XP-tp6918436p6918436.html" target="_blank" rel="nofollow" link="external">http://osgeo-org.1803224.n2.nabble.com/ogr2ogr-different-behaviour-on-different-OS-platforms-Windows-7-vs-XP-tp6918436p6918436.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em">
To start a new topic under GDAL - Dev, email <a href="/user/SendEmail.jtp?type=node&node=6920266&i=2" target="_top" rel="nofollow" link="external">[hidden email]</a> <br>
To unsubscribe from GDAL - Dev, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.
</div></blockquote></div><br>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/ogr2ogr-different-behaviour-on-different-OS-platforms-Windows-7-vs-XP-tp6918436p6920266.html">Re: ogr2ogr different behaviour on different OS platforms (Windows 7 vs XP)</a><br/>
Sent from the <a href="http://osgeo-org.1803224.n2.nabble.com/GDAL-Dev-f2022644.html">GDAL - Dev mailing list archive</a> at Nabble.com.<br/>