Here is the table I have.
CREATE TABLE "user_history" (
"id" integer DEFAULT nextval('"user_history_id_seq"'::text) NOT
NULL,
"userid" integer NOT NULL,
"ipaddr" character(15) NOT NULL,
"login_ts " timestamp with time zone,
"logout_ts " timestamp with time zone,
Constraint "user_history_pkey" Primary Key ("id")
);
I try this:
insert into user_history(id, userid, ipaddr, login_ts)
values (1, 2, '127.0.0.1', now())
And I get this:
PostgreSQL said: ERROR: Relation 'user_history' does not have attribute
'login_ts'
Obviously, I DO have login_ts. The field is nullable, so why the headache?
Thanks in advance,
Tom Veldhouse
veldy@veldy.net