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--