From: | 李江华 <ljh1469(at)alibaba-inc(dot)com> |
---|---|
To: | "David(dot)Bear(at)asu(dot)edu" <David(dot)Bear(at)asu(dot)edu>, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: stupid insert error |
Date: | 2005-06-24 00:53:59 |
Message-ID: | 20050624005401.914C566C064@smtp-hz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
David Bear,您好!
yes.of course.
you should insert the record like this:
insert into person3 (asuid, fname, lname, addedby, addedon,
slopbucket) values ('123455', 'name', 'name', 'entered', '12/12/2004', '');
======= 2005-06-24 08:12:03 您在来信中写道:=======
>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"
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
= = = = = = = = = = = = = = = = = = = =
致
礼!
李江华
ljh1469(at)alibaba-inc(dot)com
2005-06-24
From | Date | Subject | |
---|---|---|---|
Next Message | 李江华 | 2005-06-24 05:52:40 | Re: psql copy errors |
Previous Message | Tom Lane | 2005-06-24 00:48:58 | Re: stupid insert error |