Re: Problem with null timestamp fields - Mailing list pgsql-general

>         "ipaddr" character(15) NOT NULL,
>         "login_ts " timestamp with time zone,
>         "logout_ts " timestamp with time zone,
>
> 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?

Obviously, you do not.
You have 'login_ts '. Note the trailing space. Note the same for
'logout_ts'.

QED

gh


>
> Thanks in advance,
>
> Tom Veldhouse
> veldy@veldy.net