Re: DDL Triggers - Mailing list pgsql-general

From Bob Pawley
Subject Re: DDL Triggers
Date
Msg-id 968BF710708B45E9A6C109EB79DAA7A9@BobPC
Whole thread Raw
In response to Re: DDL Triggers  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: DDL Triggers  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: DDL Triggers  (Lee Hachadoorian <lee.hachadoorian@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Table growing faster than autovacuum can vacuum
Next
From: Adrian Klaver
Date:
Subject: Re: DDL Triggers