Re: [GENERAL] Triggering a function on table overwrite

2012-02-06 Thread Misa Simic
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

Re: [GENERAL] Triggering a function on table overwrite

2012-02-06 Thread Thomas Kellerer
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

Re: [GENERAL] Triggering a function on table overwrite

2012-02-06 Thread Chris Angelico
On Mon, Feb 6, 2012 at 8:42 PM, Thomas Kellerer spam_ea...@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:

Re: [GENERAL] Triggering a function on table overwrite

2012-02-06 Thread Misa Simic
+1 I could undertsand the need to point to current version... but my goal was just to give someone a hint for his problem... I have answered from bed, from my mobile phone... so it was shortcut - few taps copy/paste, and google pointed me to the link... In case I needed to worry about is it for

[GENERAL] Triggering a function on table overwrite

2012-02-05 Thread Bob Pawley
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