Re: Problem with null timestamp fields

There is a difference between "login_ts" and the
"login_ts " (notice the extra space) that I see in
your create statement.

I got the same error by using your example, but when I
changed the insert to look like this:

insert into user_history(id, userid, ipaddr,
"login_ts ") values (1, 2, '127.0.0.1', now());

Notice the " characters and the space.

Because of ambiguities like that I tend to create my
tables without the '"' character.  I also don't use
the formal 'timestamp with time zone' (but mostly
because timestamp is easier to type).

Try this:

CREATE TABLE user_history (
    id integer DEFAULT
nextval('user_history_id_seq'::text) NOT NULL,
    userid integer NOT NULL    ,
    ipaddr character(15) NOT NULL,
    login_ts  timestamp with time zone,
    logout_ts  timestamp with time zone,
    Constraint user_history_pkey Primary Key (id)
);


Jason

--- "Thomas T. Veldhouse" <veldy@veldy.net> wrote:
> Here is the table I have.
>
> CREATE TABLE "user_history" (
>         "id" integer DEFAULT
> nextval('"user_history_id_seq"'::text) NOT
> NULL,
>         "userid" integer NOT NULL,
>         "ipaddr" character(15) NOT NULL,
>         "login_ts " timestamp with time zone,
>         "logout_ts " timestamp with time zone,
>         Constraint "user_history_pkey" Primary Key
> ("id")
> );
>
>
> I try this:
>
> insert into user_history(id, userid, ipaddr,
> login_ts)
> values (1, 2, '127.0.0.1', now())
>
> And I get this:
>
> 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?
>
> Thanks in advance,
>
> Tom Veldhouse
> veldy@veldy.net
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/