On 02/15/2012 09:42 AM, Bob Pawley 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.
How could you even hope to accomplish the above? If the table is dropped there would be nothing to insert into.
DDL trigger was mentioned as a possibility on the GDAL list. Any suggestions will be welcome. Bob
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general