stupid insert error

From: David Bear <David(dot)Bear(at)asu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: stupid insert error
Date: 2005-06-24 00:12:03
Message-ID: 20050624001203.GL398@asu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I guess I'm too stupid to see the error, but I don't understand why
the following fails.

insert into person3 (asuid, fname, lname, addedby, addedon,
slopbucket) values ("123455", "name", "name", "entered", "12/12/2004", NULL);
ERROR: column "123455" does not exist

is the double quote byting me?
--
David Bear
phone: 480-965-8257
fax: 480-965-9189
College of Public Programs/ASU
Wilson Hall 232
Tempe, AZ 85287-0803
"Beware the IP portfolio, everyone will be suspect of trespassing"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2005-06-24 00:41:33 Re: stupid insert error
Previous Message Jeff Frost 2005-06-23 23:01:44 Re: restoring wal archive and pg_xlog dir