Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 446B46335E1 for ; Fri, 19 Feb 2010 07:33:57 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96305-09 for ; Fri, 19 Feb 2010 11:33:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relay.pcl-ipout01.plus.net (relay.pcl-ipout01.plus.net [212.159.7.99]) by mail.postgresql.org (Postfix) with ESMTP id B123A634390 for ; Fri, 19 Feb 2010 07:33:46 -0400 (AST) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AvsEAG4GfkvUnw4U/2dsb2JhbACbB3S8NoRnBI4l Received: from pih-relay08.plus.net ([212.159.14.20]) by relay.pcl-ipout01.plus.net with ESMTP; 19 Feb 2010 11:33:31 +0000 Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay08.plus.net with esmtp (Exim) id 1NiR6x-0007Xo-3L; Fri, 19 Feb 2010 11:33:31 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTPA id CC0452740D6; Fri, 19 Feb 2010 11:33:30 +0000 (GMT) Message-ID: <4B7E770A.5040506@archonet.com> Date: Fri, 19 Feb 2010 11:33:30 +0000 From: Richard Huxton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.9pre) Gecko/20100213 Lightning/1.0b1 Shredder/3.0.2pre MIME-Version: 1.0 To: Gordon Ross CC: "pgsql-sql@postgresql.org" Subject: Re: Unable to get UPDATE ... FROM syntax correct References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: c5ca4f5b07400b55214e50ddbc3ab593 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201002/81 X-Sequence-Number: 33680 On 19/02/10 10:58, Gordon Ross wrote: > On 19/02/2010 10:36, "Richard Huxton" wrote: > >> Works here - are you sure you don't have any triggers interfering? > > Doh ! *blush* > > Yes, I did, to stop anyone tampering with the audit table ;-) There you go - it worked :-) -- Richard Huxton Archonet Ltd