Received: from Mail.austin.rr.com (sm2.texas.rr.com [24.93.35.55]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA54526 for ; Wed, 31 May 2000 13:16:32 -0400 (EDT) (envelope-from eloehr@austin.rr.com) Received: from austin.rr.com ([24.93.36.232]) by Mail.austin.rr.com with Microsoft SMTPSVC(5.5.1877.357.35); Wed, 31 May 2000 12:03:19 -0500 Message-ID: <39354A03.F00CBE7E@austin.rr.com> Date: Wed, 31 May 2000 12:21:07 -0500 From: Ed Loehr X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686) X-Accept-Language: en MIME-Version: 1.0 To: Rick Parker CC: "'pgsql-sql@postgresql.org'" Subject: Re: psql problem References: <782BD10CBE40D31198BA00A0C9E91E4101912AAC@BCGMAIL> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/222 What is the definition of the table 'some_table'?? Regards, Ed Loehr Rick Parker wrote: > > 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. > > But if I use the following statement, everything is returned fine. > > SELECT * FROM servlet_file; > > Thanks ahead of time, > > Rick Parker