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

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 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/stati

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 docume

Re: [GENERAL] Triggering a function on table overwrite

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

[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