Re: [GENERAL] DDL Triggers
On Wed, Feb 15, 2012 at 12:42 PM, 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. > > 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/
Re: [GENERAL] DDL Triggers
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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] DDL Triggers
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 -Original Message- From: Adrian Klaver Sent: Wednesday, February 15, 2012 8:36 AM To: Bob Pawley Cc: Postgresql Subject: Re: [GENERAL] DDL Triggers On 02/15/2012 08:25 AM, Bob Pawley wrote: Could someone point me to documentation regarding DDL triggers in Postgresql? You are going to need to be more specific. Are you talking triggers that are activated by a DDL statement or a trigger that creates a DDL statement? Also what pl language(s) are you using? Bob -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] DDL Triggers
On 02/15/2012 08:25 AM, Bob Pawley wrote: Could someone point me to documentation regarding DDL triggers in Postgresql? You are going to need to be more specific. Are you talking triggers that are activated by a DDL statement or a trigger that creates a DDL statement? Also what pl language(s) are you using? Bob -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] DDL Triggers
On 02/15/2012 08:25 AM, Bob Pawley wrote: Could someone point me to documentation regarding DDL triggers in Postgresql? Bob No, because PostgreSQL does not have them (basically triggers on system tables). There is a sparse wiki page to discuss the issue at http://wiki.postgresql.org/wiki/DDL_Triggers and you can find plenty of discussions of the issue in the mailing list archives. Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] DDL Triggers
Could someone point me to documentation regarding DDL triggers in Postgresql? Bob