psql problem - Mailing list pgsql-sql

From Rick Parker
Subject psql problem
Date
Msg-id 782BD10CBE40D31198BA00A0C9E91E4101912AAC@BCGMAIL
Whole thread Raw
List 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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function-based index not used in a simple query
Next
From: Ed Loehr
Date:
Subject: Re: psql problem