Thread: DDL Triggers
Could someone point me to documentation regarding DDL triggers in Postgresql?
Bob
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
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.klaver@gmail.com
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.klaver@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
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@gmail.com
On Wed, Feb 15, 2012 at 12:42 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
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
-- 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/