Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA89234 for ; Wed, 31 May 2000 13:35:28 -0400 (EDT) (envelope-from mitch@venux.net) Received: from servbox.venux.net (matrix.venux.net [216.120.166.5]) by icebox.venux.net (Postfix) with ESMTP id 236C326208; Wed, 31 May 2000 13:40:06 -0400 (EDT) Received: from doot (doot.venux.net [10.0.0.65]) by servbox.venux.net (Postfix) with SMTP id 867822BD82; Wed, 31 May 2000 13:38:44 -0400 (EDT) Message-ID: <012001bfcb26$bb8032c0$4100000a@venux.net> From: "Mitch Vincent" To: "Rick Parker" Cc: References: <782BD10CBE40D31198BA00A0C9E91E4101912AAC@BCGMAIL> <39354A03.F00CBE7E@austin.rr.com> Subject: Re: psql problem Date: Wed, 31 May 2000 13:36:20 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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: 200005/223 > > Does anyone know why when I am in a particular DB as user postgres and use > > the following statement, why I get this error?" > > > > This is the statement; > > SELECT * FROM some_file where ID = 1; > > > > -------------------------------------------------------------------------- -- > > Error: ERROR: attribute 'id' not found > > Execution time 0.02 sec. That indicates that you have no column named 'id'.. > > But if I use the following statement, everything is returned fine. > > > > SELECT * FROM servlet_file; That's a totally different query which would yeild totally different results.. -Mitch