Re: [SQL] Function To Log Changes

2004-04-07 Thread Erik Thiele
On Mon, 5 Apr 2004 13:01:39 -0400 (EDT) "Gavin" <[EMAIL PROTECTED]> wrote: > Hi All, I have been tinkering with a function to log the changes made on > any column through a function and trigger. However, I cant think of a way > to make this work through pl/pgsql. Any one have any ideas, or is it

Re: [SQL] Function To Log Changes

2004-04-06 Thread elein
A plpython solution is available in Issue #66 of PostgreSQL GeneralBits. http://www.varlena.com/GeneralBits/66 Let me know if this helps. elein On Mon, Apr 05, 2004 at 01:01:39PM -0400, Gavin wrote: > Hi All, I have been tinkering with a function to log the changes made on > any column through a

Re: [SQL] Function To Log Changes

2004-04-05 Thread Tom Lane
"Gavin" <[EMAIL PROTECTED]> writes: > Hi All, I have been tinkering with a function to log the changes made on > any column through a function and trigger. However, I cant think of a way > to make this work through pl/pgsql. plpgsql won't do it, but you could do it in pltcl, I believe. Or resort

Re: [SQL] Function To Log Changes

2004-04-05 Thread Josh Berkus
Gavin, > Hi All, I have been tinkering with a function to log the changes made on > any column through a function and trigger. However, I cant think of a way > to make this work through pl/pgsql. Any one have any ideas, or is it just > not possible? It could be done, but would be extremely slow

[SQL] Function To Log Changes

2004-04-05 Thread Gavin
Hi All, I have been tinkering with a function to log the changes made on any column through a function and trigger. However, I cant think of a way to make this work through pl/pgsql. Any one have any ideas, or is it just not possible? SNIP create or replace function logchange2() returns OPAQUE a