Re: [GENERAL] Dynamic datalogging function/scheme

2006-02-16 Thread rob
Thanks Mike! Much appreciated. -Rob ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Dynamic datalogging function/scheme

2006-02-15 Thread Mike Rylander
I developed, and have been using, this[1] and it's been working fine for me. :) http://open-ils.org/blog/?p=28 On 15 Feb 2006 10:10:29 -0800, rob <[EMAIL PROTECTED]> wrote: > Hello, > > > > Looking for advice on creating as dynamic a datalogging scheme as I can > using plpgsql. > > > The idea wou

[GENERAL] Dynamic datalogging function/scheme

2006-02-15 Thread rob
Hello, Looking for advice on creating as dynamic a datalogging scheme as I can using plpgsql. The idea would be to have a trigger function that I could drop on any table in my database. Then on update, the function would iterate through each field, and check to see if NEW. <> OLD.. Then a fu