Thread: Triggering a function on table overwrite

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

Misa Simic, 06.02.2012 10:35:
> 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,


Please do not link to outdated documentation, use "current" instead of the version number:

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

On Mon, Feb 6, 2012 at 8:42 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> Misa Simic, 06.02.2012 10:35:
>
>> 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
>>
>
> Please do not link to outdated documentation, use "current" instead of the
> version number:
>
> http://www.postgresql.org/docs/current/static/plpgsql-trigger.html

It seems that Googling for documentation often brings up old versions.
Would it be difficult to have all those pages have a little banner up
the top saying something like "NOTE: This documentation pertains to a
previous version of Postgres. Documentation for the latest version of
Postgres can be found at http://blah/blah/current/blah.html"?

Chris Angelico