Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 2DF77477366 for ; Thu, 13 Jun 2002 18:57:21 -0400 (EDT) Received: from email02.aon.at (WARSL402PIP7.highway.telekom.at [195.3.96.94]) by postgresql.org (Postfix) with SMTP id 73CBD477226 for ; Thu, 13 Jun 2002 18:26:50 -0400 (EDT) Received: (qmail 215856 invoked from network); 13 Jun 2002 22:26:52 -0000 Received: from m157p024.dipool.highway.telekom.at (HELO cantor) ([62.46.9.152]) (envelope-sender ) by qmail2rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 13 Jun 2002 22:26:52 -0000 From: Manfred Koizar To: vernonw@gatewaytech.com Cc: pgsql-sql@postgresql.org Subject: Re: Please help me out on this insert error Date: Fri, 14 Jun 2002 00:26:29 +0200 Message-ID: <3s6igukoh2bmechd9fnhj05os7mnup2q94@4ax.com> References: In-Reply-To: X-Mailer: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/197 X-Sequence-Number: 8162 On Thu, 13 Jun 2002 13:16:29 +0800, Vernon Wu wrote: > >Command: > >Insert into profile (userid, haveChildren)values('id98', 'No'); > >Error: > >ERROR: Relation 'profile' does not have attribute 'havaChildren' ^ cut'n'paste error here ? >Table: > Table "profile" > Column | Type | Modifiers >--------------+-----------------------+---------- > userid | character varying(25) | not null > [...] > haveChildren | character varying(20) | not null Anyway, try Insert into profile (userid, "haveChildren") values('id98', 'No'); Servus Manfred