<HTML><HEAD>
<META content="text/html; charset=ISO-8859-1" http-equiv=Content-Type></HEAD>
<BODY dir=ltr bgColor=#ffffff text=#000000>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>I am trying to add columns to a table (which I am able to do), then add a
trigger to that table in order to trigger an existing function.</DIV>
<DIV> </DIV>
<DIV>My basic problem is that the ogr2ogr switch (ie: –lco Dim=2) appear to only
work with an -overwrite. They don’t seem to work with an -append.</DIV>
<DIV> </DIV>
<DIV>As -overwrite drops the existing table, as well as its trigger, I need to
replace the trigger after the table is restored.</DIV>
<DIV> </DIV>
<DIV>Does this make sense? </DIV>
<DIV> </DIV>
<DIV>Perhaps there is another way of doing this?</DIV>
<DIV> </DIV>
<DIV>Bob</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV style="FONT: 10pt tahoma">
<DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=chander@otg-nc.com
href="mailto:chander@otg-nc.com">Chander Ganesan</A> </DIV>
<DIV><B>Sent:</B> Tuesday, February 14, 2012 10:27 AM</DIV>
<DIV><B>To:</B> <A title=gdal-dev@lists.osgeo.org
href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</A> </DIV>
<DIV><B>Subject:</B> Re: [gdal-dev] ogr2ogr</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">I'm
not certain what you are trying to do, but...<BR><BR>Consider the SQL "UNION",
"UNION ALL", "INTERSECT", or "INTERSECT ALL" statements perhaps? They
allow you to combine the results of two queries into a single result set (as a
single query.)<BR><BR>Chander<BR><BR>On 2/14/12 1:24 PM, Bob Pawley wrote:
<BLOCKQUOTE cite=mid:B8B7F192430A4712BC447E4529317630@BobPC type="cite">
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Arial Narrow'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV><FONT size=5>Is there a method of having two –sql commands in one command
prompt execution.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=5>I have attempted </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=5>1. –sql “first statement ” –sql “second“</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=5>2. –sql “first; second“</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=5>3. sql “first “ “second“</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=5>4. –sql “first” –overwrite –skipfailures -sql “second” (an
attempt to separate the two).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=5>Bob</FONT></DIV></DIV></DIV><BR>
<FIELDSET class=mimeAttachmentHeader></FIELDSET> <BR><PRE wrap="">_______________________________________________
gdal-dev mailing list
<A class=moz-txt-link-abbreviated href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</A>
<A class=moz-txt-link-freetext href="http://lists.osgeo.org/mailman/listinfo/gdal-dev">http://lists.osgeo.org/mailman/listinfo/gdal-dev</A></PRE></BLOCKQUOTE><BR><BR>
<P>
<HR>
_______________________________________________<BR>gdal-dev mailing
list<BR>gdal-dev@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/gdal-dev</DIV></DIV></DIV></BODY></HTML>