Please help me out on this insert error

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.

Responses

Browse pgsql-sql by date

  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