From: | Lee Hachadoorian <lee(dot)hachadoorian(at)gmail(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DDL Triggers |
Date: | 2012-02-15 21:10:39 |
Message-ID: | CANnCtnLnM7K=HU5G2Tyg3zQPxuNsx7OVaj1Z2+xHHQC5YzQJpA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Feb 15, 2012 at 12:42 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
> I have a table that is generated through ogr2ogr.
>
> To get ogr2ogr working the way I want, I need to use the -overwrite
> function. If I use the append function information is lost. Something to do
> with the way the switches work.
>
> Overwrite drops the existing table and also the attached trigger .
>
> I am attempting to have the dropped table trigger a function as it is
> being populated by insert commands.
>
> DDL trigger was mentioned as a possibility on the GDAL list.
>
> Any suggestions will be welcome.
>
> Bob
>
Are you sure ogr2ogr is the right tool for what you want to accomplish?
Reading between the lines, it *seems* like you intend to do an append (SQL
INSERT), but ogr2ogr isn't working the way you want, forcing you to use
overwrite (DROP/CREATE TABLE). Trying to use a DDL trigger seems like a
roundabout way to get what you want when the problem is ogr2ogr.
So, I would back up and ask, what are you trying to do, and what
information is being lost using -append?
Also, you mentioned asking this on the GDAL list, did you try the PostGIS
list?
--Lee
--
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freecity.commons.gc.cuny.edu/
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Keller | 2012-02-15 21:37:08 | Re: [postgis-users] ST_AsJpeg |
Previous Message | Osmel Barreras Piñera | 2012-02-15 20:47:35 | SPI functions to work with the Execution Plan |