Re: Problem with null timestamp fields

From: GH <grasshacker(at)over-yonder(dot)net>
To: "Thomas T(dot) Veldhouse" <veldy(at)veldy(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with null timestamp fields
Date: 2001-06-28 03:03:41
Message-ID: 20010627220341.A81663@over-yonder.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)veldy(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Molter 2001-06-28 03:11:52 Re: Re: Red Hat to support PostgreSQL
Previous Message Thomas T. Veldhouse 2001-06-28 02:35:05 Problem with null timestamp fields