Re: Problem with null timestamp fields

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
>