Thread

1. PostgreSQL said: ERROR: Attribute 'id' not found

   eric.jones@hua.army.mil — 2002-04-09T23:54:57Z

   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
   
   

2. Re: PostgreSQL said: ERROR: Attribute 'id' not found

   Doug McNaught <doug@wireboard.com> — 2002-04-10T00:14:10Z

   eric.jones@hua.army.mil writes:
   
   > 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;
   
   Try this:
   
   SELECT * from s_users where "ID" = 1;
   
   -Doug
   -- 
   Doug McNaught       Wireboard Industries      http://www.wireboard.com/
   
         Custom software development, systems and network consulting.
         Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...
   
   

3. Re: PostgreSQL said: ERROR: Attribute 'id' not found

   Darren Ferguson <darren@crystalballinc.com> — 2002-04-10T00:19:36Z

   
   select * from s_users;
    ID | fname  |  lname   | ako |  phone   |    email     | rank_id |
   status_id 
   ----+--------+----------+-----+----------+--------------+---------+-----------
     1 | Darren | Ferguson | ako | 49499494 | d
   @phone.com |       5 |         3
   (1 row)
   
   
   
   dev=> select * from s_users where ID = 1;
   ERROR:  Attribute 'id' not found
   
   
   
   dev=> select * from s_users where "ID" = 1;
    ID | fname  |  lname   | ako |  phone   |    email     | rank_id |
   status_id 
   ----+--------+----------+-----+----------+--------------+---------+-----------
     1 | Darren | Ferguson | ako | 49499494 | d
   @phone.com |       5 |         3
   (1 row)
   
   Postgres will convert ID to id unless you put "" around it.
   
   So the system says id that aint a field in that table and throws an error
   
   HTH 
   
   Darren Ferguson
   
   On Tue, 9 Apr 2002 eric.jones@hua.army.mil wrote:
   
   > 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
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 4: Don't 'kill -9' the postmaster
   >