Re: Triggering a function on table overwrite

From: Misa Simic <misa(dot)simic(at)gmail(dot)com>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>, Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Triggering a function on table overwrite
Date: 2012-02-06 09:35:21
Message-ID: 1789181104245002529@unknownmsgid
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Bob,

I guess with "overwrite the table" you mean to fill some columns with your
values in trigger...

If that is the case, in docs is example:

http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html

Kind Regards,

Misa

Sent from my Windows Phone
------------------------------
From: Bob Pawley
Sent: 06/02/2012 06:57
To: Postgresql
Subject: [GENERAL] Triggering a function on table overwrite

Hi

Normally when I need to run a function during an insert I make it a trigger
function of that table.

However, in this case, I need to overwrite the table with which the trigger
is attached.

I would appreciate any suggestions on how to do this.

Bob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2012-02-06 09:42:35 Re: Triggering a function on table overwrite
Previous Message Lockas 2012-02-06 06:37:40 Re: Error while importing CSV file