Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 613EA47704E
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 18:57:29 -0400 (EDT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178])
	by postgresql.org (Postfix) with ESMTP id C4F1F475B29
	for <pgsql-sql@postgresql.org>; Thu, 13 Jun 2002 18:31:14 -0400 (EDT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 0F838D600; Thu, 13 Jun 2002 15:31:17 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 053875C01; Thu, 13 Jun 2002 15:31:16 -0700 (PDT)
Date: Thu, 13 Jun 2002 15:31:16 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Vernon Wu <vernonw@gatewaytech.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: Please help me out on this insert error
In-Reply-To: <PJD0YU9RP4XGBTQF0OYU06DADAQLGA.3d0848ad@kimiko>
Message-ID: <20020613153011.Y8462-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200206/196
X-Sequence-Number: 8161


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. In general, it's
safer to just use all lowercase names. :)