From sweiss@ionsol.com.au Thu Nov 23 17:44:28 2000 Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eANHiSA76422 for ; Thu, 23 Nov 2000 12:44:28 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from bigblue.ionsol.com.au (ns.ionsol.com.au [210.8.211.2] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAK3nYs95002 for ; Sun, 19 Nov 2000 22:49:35 -0500 (EST) (envelope-from sweiss@ionsol.com.au) Received: from seanwin98 ([192.168.0.4]) by bigblue.ionsol.com.au (8.9.3/8.9.3) with SMTP id NAA23044 for ; Mon, 20 Nov 2000 13:21:20 +1000 Message-ID: <00ce01c052a1$667db2e0$0400a8c0@seanwin98> From: "Sean Weissensee" To: Subject: Date: Mon, 20 Nov 2000 13:24:32 +1000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CB_01C052F5.38083120" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200011/208 X-Sequence-Number: 239 This is a multi-part message in MIME format. ------=_NextPart_000_00CB_01C052F5.38083120 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Why does this error come up ionsol=3D> update quickstock set ItemDesc =3D '10000',Qty =3D 0.0,salespri= ce =3D 0 .0 where StockID =3D '8597' \g ERROR: Relation 'quickstock' does not have attribute 'itemdesc'=20=20=20 when ItemDesc does exist. Sean ------=_NextPart_000_00CB_01C052F5.38083120 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Why does this error come up
 
 ionsol=3D> update quickstock set = ItemDesc =3D=20 '10000',Qty =3D 0.0,salesprice =3D 0
.0 where StockID =3D '8597' \g
E= RROR: =20 Relation 'quickstock' does not have attribute 'itemdesc'  =20
 
when ItemDesc does exist.
 
Sean
------=_NextPart_000_00CB_01C052F5.38083120-- From reedstrm@rice.edu Thu Nov 23 20:50:03 2000 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 eANKo3A22995 for ; Thu, 23 Nov 2000 15:50:03 -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, 23 Nov 2000 14:49:57 -0600 (CST) Date: Thu, 23 Nov 2000 14:49:57 -0600 From: "Ross J. Reedstrom" To: Sean Weissensee Cc: pgsql-sql@postgresql.org Subject: Re: Message-ID: <20001123144957.A23137@rice.edu> Mail-Followup-To: Sean Weissensee , pgsql-sql@postgresql.org References: <00ce01c052a1$667db2e0$0400a8c0@seanwin98> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <00ce01c052a1$667db2e0$0400a8c0@seanwin98>; from sweiss@ionsol.com.au on Mon, Nov 20, 2000 at 01:24:32PM +1000 X-Archive-Number: 200011/212 X-Sequence-Number: 243 On Mon, Nov 20, 2000 at 01:24:32PM +1000, Sean Weissensee wrote: > Why does this error come up > > ionsol=> update quickstock set ItemDesc = '10000',Qty = 0.0,salesprice = 0 > .0 where StockID = '8597' \g > ERROR: Relation 'quickstock' does not have attribute 'itemdesc' > > when ItemDesc does exist. Because SQL is case insensitive, by default. Postgresql implements this by downcasing all identifiers (table and column names) unless quoted with double quotes. I'm guessing that you created this table via MS-Access. The ODBC driver quotes identifiers by default. Try this: update quickstock set "ItemDesc" = '10000',"Qty" = 0.0,salesprice = 0.0 where "StockID" = '8597' \g Ross -- Open source code is like a natural resource, it's the result of providing food and sunshine to programmers, and then staying out of their way. [...] [It] is not going away because it has utility for both the developers and users independent of economic motivations. Jim Flynn, Sunnyvale, Calif.