Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 63ED6477554
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 19:42:41 -0400 (EDT)
Received: from pd5mo2so.prod.shaw.ca (h24-71-223-10.cg.shawcable.net
	[24.71.223.10]) by postgresql.org (Postfix) with ESMTP id 89DEE477312
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 18:50:17 -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 <0GXO0019623KNG@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 16:50:08 -0600 (MDT)
Received: from pn2ml6so.prod.shaw.ca
	(pn2ml6so-qfe0.prod.shaw.ca [10.0.121.150]) by l-daemon
	(iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12 2002))
	with ESMTP id <0GXO008MZ23P1O@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 16:50:13 -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 <0GXO00F2J23NSK@l-daemon> for pgsql-sql@postgresql.org;
	Thu, 13 Jun 2002 16:50:12 -0600 (MDT)
Date: Thu, 13 Jun 2002 15:50:07 +0800
From: Vernon Wu <vernonw@gatewaytech.com>
Subject: Re: Please help me out on this insert error
In-reply-to: <20020613153011.Y8462-100000@megazone23.bigpanda.com>
To: pgsql-sql@postgresql.org
Reply-To: vernonw@gatewaytech.com
Message-id: <TQG532X546246UOYURGFBXV542Y.3d084eaf@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/200
X-Sequence-Number: 8165

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

>
>On Thu, 13 Jun 2002, Vernon Wu wrote:
>
>> I, however, didn't use double quote mark when I created the table at all.
>
>If you used an interface to generate the table def, alot of them add the
>quote marks behind your back when they do the creation. 

That must be what really happended without my knowledge. I used the pgAdmin to create the table. So, it is safer to 
create tables using the command line.

In general, it's
>safer to just use all lowercase names. :)
>
>

That is a separated issue, is it?

Thanks.

v