Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1MNI9x30937 for ; Thu, 22 Feb 2001 18:18:10 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Thu, 22 Feb 2001 17:18:06 -0600 (CST) Date: Thu, 22 Feb 2001 17:18:06 -0600 From: "Ross J. Reedstrom" To: =?iso-8859-1?Q?Bj=F8rn_T_Johansen?= Cc: pgsql-sql@postgresql.org Subject: Re: Strange parse error?? Message-ID: <20010222171806.A28996@rice.edu> Mail-Followup-To: =?iso-8859-1?Q?Bj=F8rn_T_Johansen?= , pgsql-sql@postgresql.org References: <919338627.20010222234930@softinn.no> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.0i In-Reply-To: <919338627.20010222234930@softinn.no>; from bjorntj@softinn.no on Thu, Feb 22, 2001 at 11:49:30PM +0100 X-Archive-Number: 200102/342 X-Sequence-Number: 1538 On Thu, Feb 22, 2001 at 11:49:30PM +0100, Bjørn T Johansen wrote: > I am trying to do a simple update (or at least I thought it was > simple), but I just keep getting a parse error, saying: > > Error executing query > > Update "Config" Set "Wave" = 'F:\wav\BTJ.wav',"Answer" = 20, > "Recordwav" ='F:\wav\',"CalledID" = '12345678' where "Recno" = 1 > > PostgreSQL error message: > ERROR: parser: parse error at or near "12345678" Backslashes are used for quoting, so what you're trying to do looks something like this to the server: Update "Config" Set "Wave" = 'F:wavBTJ.wav',"Answer" = 20, "Recordwav" ='F:wav\',"CalledID" = '12345678' where "Recno" = 1 You could confirm by turning up debugging on the server and check the logs. So, it's trying to store the string : F:wav',"CalledID" = (with trailing space, even) in Recordwav. Try doubling your backslashes, as so: Update "Config" Set "Wave" = 'F:\\wav\\BTJ.wav',"Answer" = 20, "Recordwav" ='F:\\wav\\',"CalledID" = '12345678' where "Recno" = 1 Ross