psql problem

From: Rick Parker <Rick_Parker(at)boscomm(dot)net>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: psql problem
Date: 2000-05-31 16:51:57
Message-ID: 782BD10CBE40D31198BA00A0C9E91E4101912AAC@BCGMAIL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ed Loehr 2000-05-31 17:21:07 Re: psql problem
Previous Message Tom Lane 2000-05-31 15:53:25 Re: Function-based index not used in a simple query