Re: DDL Triggers

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-02-15 17:54:18 Re: Reassigned Owned Error- unexpected classid 2328
Previous Message Bob Pawley 2012-02-15 17:42:46 Re: DDL Triggers