Postgres Pro
Downloads
Home   >   mailing lists

Re: Triggering a function on table overwrite - Mailing list pgsql-general

From Misa Simic
Subject Re: Triggering a function on table overwrite
Date
Msg-id 1789181104245002529@iso-8859-1msgid
Whole thread Raw
In response to Triggering a function on table overwrite  ("Bob Pawley" <rjpawley@shaw.ca>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Backup database remotely
Next
From: Misa Simic
Date:
Subject: Re: How to create crosstab with 3 values in every crosstab column