Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id D40D4477100
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 17:10:12 -0400 (EDT)
Received: from pd4mo3so.prod.shaw.ca (h24-71-223-10.cg.shawcable.net
	[24.71.223.10]) by postgresql.org (Postfix) with ESMTP id 4682F4770C1
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 16:16:41 -0400 (EDT)
Received: from pd2mr4so.prod.shaw.ca (pd2mr4so-ser.prod.shaw.ca
 [10.0.141.107])
	by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12
	2002))
	with ESMTP id <0GXN00AQ8UZJ31@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 14:16:31 -0600 (MDT)
Received: from pn2ml10so.prod.shaw.ca
	(pn2ml10so-qfe0.prod.shaw.ca [10.0.121.80])
	by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12
	2002))
	with ESMTP id <0GXN001SXUZORH@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 14:16:36 -0600 (MDT)
Received: from kimiko (h24-78-152-126.vc.shawcable.net [24.78.152.126])
	by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12
	2002))
	with SMTP id <0GXN00773UZLCV@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 14:16:33 -0600 (MDT)
Date: Thu, 13 Jun 2002 13:16:29 +0800
From: Vernon Wu <vernonw@gatewaytech.com>
Subject: Please help me out on this insert error
To: pgsql-sql@postgresql.org
Reply-To: vernonw@gatewaytech.com
Message-id: <TQWRKJIWV95LKS653WWR835NKIB0.3d082aad@kimiko>
MIME-version: 1.0
X-Mailer: Opera 6.01 build 1041
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
X-Priority: 2 (High)
X-Archive-Number: 200206/185
X-Sequence-Number: 8150


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.