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
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 |