Problem with null timestamp fields

From: "Thomas T(dot) Veldhouse" <veldy(at)veldy(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problem with null timestamp fields
Date: 2001-06-28 02:35:05
Message-ID: 006801c0ff7a$f0a19c30$0101a8c0@cascade
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)veldy(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GH 2001-06-28 03:03:41 Re: Problem with null timestamp fields
Previous Message Alex Pilosov 2001-06-28 01:21:20 Re: Blobs in PostgreSQL