Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id ACD414771D5
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 18:56:57 -0400 (EDT)
Received: from pd3mo2so.prod.shaw.ca (h24-71-223-10.cg.shawcable.net
	[24.71.223.10]) by postgresql.org (Postfix) with ESMTP id DD6E8476087
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 18:24:39 -0400 (EDT)
Received: from pd4mr1so.prod.shaw.ca
	(pd4mr1so-qfe3.prod.shaw.ca [10.0.141.212]) by l-daemon
	(iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002))
	with ESMTP id <0GXO004MA0WWUM@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 16:24:32 -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 <0GXO0072Z0X0KZ@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 16:24: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 <0GXO008OU0WWDR@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 16:24:33 -0600 (MDT)
Date: Thu, 13 Jun 2002 15:24:29 +0800
From: Vernon Wu <vernonw@gatewaytech.com>
Subject: Re: Please help me out on this insert error
In-reply-to: <20020613150910.N8240-100000@megazone23.bigpanda.com>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Reply-To: vernonw@gatewaytech.com
Message-id: <PJD0YU9RP4XGBTQF0OYU06DADAQLGA.3d0848ad@kimiko>
MIME-version: 1.0
X-Mailer: Opera 6.01 build 1041
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
X-Priority: 3 (Normal)
X-Archive-Number: 200206/198
X-Sequence-Number: 8163


You are right, Steve. It needs the double quote mark. After I use the double quote mark, an error message is:

ERROR:  ExecAppend: Fail to add null value in not null attribute ...

which is right since I don't have non-null value to non-null field yet.

I, however, didn't use double quote mark when I created the table at all.

Now, I need to figure out how to add double quote mark in Java code query string.

v.

6/14/2002 6:12:18 AM, Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:

>On Thu, 13 Jun 2002, Vernon Wu wrote:
>
>>
>> Command:
>>
>> Insert into profile (userid, haveChildren)values('id98', 'No');
>
>You presumably used double quotes when creating the column, so
>you need to use them to refer to the column from that point on:
>
>insert into profile(userid, "haveChildren") ...
>
>
>