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.
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.
As -overwrite drops the existing table, as well as its trigger, I need to
replace the trigger after the table is restored.
Does this make sense?
Perhaps there is another way of doing this?
Bob
From: Chander Ganesan
Sent: Tuesday, February 14, 2012 10:27 AM
To: [email protected]
Subject: Re: [gdal-dev] ogr2ogr
I'm not certain what you are trying to do, but...
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.)
Chander
On 2/14/12 1:24 PM, Bob Pawley wrote:
Is there a method of having two –sql commands in one command prompt execution.
I have attempted
1. –sql “first statement ” –sql “second“
2. –sql “first; second“
3. sql “first “ “second“
4. –sql “first” –overwrite –skipfailures -sql “second” (an attempt to
separate the two).
Bob
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
--------------------------------------------------------------------------------
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
