Yes, that was it. It should have been more obvious had I looked closer. A
second pair of eyes are always helpful. Still, I am a bit amazed that the
database allows this (trailing or leading spaces in the column names).
Thanks for you help!
Tom Veldhouse
veldy@veldy.net
----- Original Message -----
From: "GH" <grasshacker@over-yonder.net>
To: "Thomas T. Veldhouse" <veldy@veldy.net>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, June 27, 2001 10:03 PM
Subject: Re: [GENERAL] Problem with null timestamp fields
> > "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
