From: | Vernon Wu <vernonw(at)gatewaytech(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Please help me out on this insert error |
Date: | 2002-06-13 05:16:29 |
Message-ID: | TQWRKJIWV95LKS653WWR835NKIB0.3d082aad@kimiko |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Command:
Insert into profile (userid, haveChildren)values('id98', 'No');
Error:
ERROR: Relation 'profile' does not have attribute 'havaChildren'
Table:
Table "profile"
Column | Type | Modifiers
--------------+-----------------------+----------
userid | character varying(25) | not null
sex | character(1) | not null
dob | date | not null
pob | character varying(20) |
status | character varying(20) | not null
ethnicity | character varying(20) | not null
religion | character varying(20) | not null
bodytype | character varying(20) | not null
height | numeric(3,0) | not null
weight | numeric(2,0) | not null
education | character varying(20) |
occupation | character varying(20) | not null
incomelow | numeric(6,0) | not null
incomeup | numeric(6,0) | not null
haveChildren | character varying(20) | not null
wantChildren | character varying(20) | not null
drinking | character varying(20) |
smoking | character varying(20) | not null
narration | text |
Primary key: pro_pkey
What is wrong here?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-06-13 05:29:26 | Re: How to remove contraint |
Previous Message | Josh Berkus | 2002-06-13 04:35:15 | Re: Case insensitive select |