[GENERAL] Triggering from a specific column update

2009-11-15 Thread Bob Pawley
PostgreSQL does not support specific column updates in triggers. I found this statement on a blog. Is there a workaround for this? I've attempted using 'new' (refering to the specific column) without success. Bob

Re: [GENERAL] Triggering from a specific column update

2009-11-15 Thread Tom Lane
Bob Pawley rjpaw...@shaw.ca writes: PostgreSQL does not support specific column updates in triggers. I found this statement on a blog. Is there a workaround for this? If you'd explain what you think that statement means, maybe we could help you ... regards, tom lane

Re: [GENERAL] Triggering from a specific column update

2009-11-15 Thread Bob Pawley
] Triggering from a specific column update Bob Pawley rjpaw...@shaw.ca writes: PostgreSQL does not support specific column updates in triggers. I found this statement on a blog. Is there a workaround for this? If you'd explain what you think that statement means, maybe we could help you

Re: [GENERAL] Triggering from a specific column update

2009-11-15 Thread Tom Lane
Bob Pawley rjpaw...@shaw.ca writes: Hope this elucidates you? No, it's all handwaving. In particular, showing only a fragment from a case that does work as you expect doesn't illuminate what's not working. Please show the whole table definition, the whole trigger, and the specific case that's

Re: [GENERAL] Triggering from a specific column update

2009-11-15 Thread Adrian Klaver
On Sunday 15 November 2009 5:18:20 pm Tom Lane wrote: Bob Pawley rjpaw...@shaw.ca writes: Hope this elucidates you? No, it's all handwaving. In particular, showing only a fragment from a case that does work as you expect doesn't illuminate what's not working. Please show the whole table