X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 33BFF32A10E for ; Thu, 21 Oct 2004 00:09:28 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08470-01 for ; Wed, 20 Oct 2004 23:09:15 +0000 (GMT) Received: from sj-iport-1.cisco.com (sj-iport-1-in.cisco.com [171.71.176.70]) by svr1.postgresql.org (Postfix) with ESMTP id 991CB32A0AE for ; Thu, 21 Oct 2004 00:09:16 +0100 (BST) Received: from sj-core-1.cisco.com (171.71.177.237) by sj-iport-1.cisco.com with ESMTP; 20 Oct 2004 16:19:27 -0700 X-BrightmailFiltered: true Received: from cjwhitew2k02 ([128.107.172.53]) by sj-core-1.cisco.com (8.12.10/8.12.6) with ESMTP id i9KN96k2017529; Wed, 20 Oct 2004 16:09:06 -0700 (PDT) Message-Id: <200410202309.i9KN96k2017529@sj-core-1.cisco.com> Reply-To: From: "Chris White (cjwhite)" To: "'Scott Marlowe'" Cc: Subject: Re: Need help Date: Wed, 20 Oct 2004 16:09:08 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <1098309203.21035.61.camel@localhost.localdomain> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Thread-Index: AcS27vrV9mq2kVq4QdG2XzLWnI2zBAACmcmQ X-PMX-Version: 4.7.0.111621 X-from-outside-Cisco: [128.107.172.53] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/266 X-Sequence-Number: 15259 It was a mistype, it was not a cut and paste, as I do not have email on the system that has access to the system running the DB. There is meant to be no space in messageid -----Original Message----- From: Scott Marlowe [mailto:smarlowe@qwest.net] Sent: Wednesday, October 20, 2004 2:53 PM To: cjwhite@cisco.com Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Need help On Wed, 2004-10-20 at 12:57, Chris White (cjwhite) wrote: > I am running 7.4.2 and I am seeing a strange error. I am using jdbc to > update a table with the following statement: > > update vm_message set usecount=4 where messsage id='1234567'; Is that really your query, cut and pasted? Is that space between message and id supposed to be there? Just wondering.