PostgreSQL said: ERROR: Attribute 'id' not found
От | eric.jones@hua.army.mil |
---|---|
Тема | PostgreSQL said: ERROR: Attribute 'id' not found |
Дата | |
Msg-id | 506889585A61D5119B460008C7A47E6501B29E43@HUADOIMC2PO обсуждение исходный текст |
Ответы |
Re: PostgreSQL said: ERROR: Attribute 'id' not found
|
Список | 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 по дате отправления: