From: Vernon Wu <vernonw@gatewaytech.com>
To: pgsql-sql@postgresql.org
Subject: Please help me out on this insert error
Date: Thu, 13 Jun 2002 13:16:29 +0800
Message-ID: <TQWRKJIWV95LKS653WWR835NKIB0.3d082aad@kimiko> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vernonw@gatewaytech.com
Subject: Re: Please help me out on this insert error
In-Reply-To: <TQWRKJIWV95LKS653WWR835NKIB0.3d082aad@kimiko>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox