Problem with null timestamp fields

Поиск
Список
Период
Сортировка
От Thomas T. Veldhouse
Тема Problem with null timestamp fields
Дата
Msg-id 006801c0ff7a$f0a19c30$0101a8c0@cascade
обсуждение исходный текст
Ответы Re: Problem with null timestamp fields
Re: Problem with null timestamp fields
Список 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@veldy.net


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Why is NULL not indexable?
Следующее
От: GH
Дата:
Сообщение: Re: Problem with null timestamp fields