PostgreSQL said: ERROR: Attribute 'id' not found - Mailing list pgsql-general

From eric.jones@hua.army.mil
Subject PostgreSQL said: ERROR: Attribute 'id' not found
Date
Msg-id 506889585A61D5119B460008C7A47E6501B29E43@HUADOIMC2PO
Whole thread Raw
Responses Re: PostgreSQL said: ERROR: Attribute 'id' not found
List pgsql-general
Hello All!

Version - 7.2.1
OS - FreeBSD

    I've encountered the following error when ever doing a select
statement on any table in my DB:

PostgreSQL said: ERROR: Attribute 'id' not found

    The select statement I'm doing is:

        select * from s_users where ID = 1;

    This fails when I do an "ID" or an "id".

    I've tried it both in PHP PG Admin and from the command line.

My table looks like this:

CREATE TABLE "s_users" (
   "ID" int8 DEFAULT nextval('"s_users_seq"'::text) NOT NULL,
   "fname" text NOT NULL,
   "lname" text NOT NULL,
   "ako" text NOT NULL,
   "phone" text,
   "email" text NOT NULL,
   "rank_id" int8,
   "status_id" int8 DEFAULT 2 NOT NULL,
   CONSTRAINT "s_users_pkey" PRIMARY KEY ("ID")
);

    Anyone know why this is happening and how to fix it? Thanks in
advance!

Eric Jones (Contractor)
FDIC Web Enabler
E-mail: jonese@hua.army.mil
Office - 520-533-6628
Cell - 520-930-2136
Email Pager - 5209802136@messaging.nextel.com

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Regular Expression INTRO [long] [OT]
Next
From: Doug McNaught
Date:
Subject: Re: PostgreSQL said: ERROR: Attribute 'id' not found