X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AF12A47648C for ; Wed, 14 May 2003 17:41:26 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 58998-10 for ; Wed, 14 May 2003 17:41:21 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id 49CBD4764A8 for ; Wed, 14 May 2003 17:41:21 -0400 (EDT) Received: from lerlaptop-red.iadfw.net (lerlaptop-red.iadfw.net [207.136.3.72]) (authenticated bits=0) by lerami.lerctr.org (8.12.9/8.12.9/20030225) with ESMTP id h4ELfIKK008776; Wed, 14 May 2003 16:41:19 -0500 (CDT) Date: Wed, 14 May 2003 16:41:18 -0500 From: Larry Rosenman To: Joe Conway Cc: pgsql-sql@postgresql.org Subject: Re: PL/pgSQL: Logging Trigger. Advice/comments/other? Message-ID: <485430000.1052948478@lerlaptop-red.iadfw.net> In-Reply-To: <3EC2B604.6090308@joeconway.com> References: <382520000.1052942661@lerlaptop-red.iadfw.net> <3EC2B604.6090308@joeconway.com> X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/303 X-Sequence-Number: 13468 --On Wednesday, May 14, 2003 14:32:52 -0700 Joe Conway wrote: > Larry Rosenman wrote: >> Ok, I finally finished this damn trigger to log changes to ONE frapping >> table. >> >> I'm wondering if any of you PL/pgSQL guru's out there see any better way >> to do >> this: > > I haven't had the time to follow this thread, but depending on your > needs, maybe this will help (uses dblink_current_query() from > contrib/dblink): [snip] Oooohhhhh.... This looks promising. (now, can I migrate the damn 7.2.1 to 7.3.2????). Thanks Joe! LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749