Re: Problem with null timestamp fields
От | Thomas T. Veldhouse |
---|---|
Тема | Re: Problem with null timestamp fields |
Дата | |
Msg-id | 007101c0ff82$831d70f0$0101a8c0@cascade обсуждение исходный текст |
Ответ на | Problem with null timestamp fields ("Thomas T. Veldhouse" <veldy@veldy.net>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: