Re: DDL Triggers

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>
Cc: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: DDL Triggers
Date: 2012-02-15 17:42:46
Message-ID: 968BF710708B45E9A6C109EB79DAA7A9@BobPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-02-15 17:50:13 Re: DDL Triggers
Previous Message Marti Raudsepp 2012-02-15 17:33:30 Re: Table growing faster than autovacuum can vacuum