Received: from yukari.lineo.com (yukari.lineo.com [207.179.37.69]) by hub.org (8.10.1/8.10.1) with ESMTP id e6E9Io001376 for ; Fri, 14 Jul 2000 05:18:51 -0400 (EDT) Received: by yukari.lineo.com (Postfix, from userid 440) id 5B03D9B020; Fri, 14 Jul 2000 03:21:49 -0600 (MDT) Date: Fri, 14 Jul 2000 03:21:49 -0600 From: John BEPPU To: pgsql-sql@postgresql.org Subject: case-sensitivity and the serial type Message-ID: <20000714032149.H1265@yukari.lineo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2i X-Archive-Number: 200007/147 I've been using the debian package of postgresql (7.0-release-1) and I've been able to say something like: create table blah ( id serial ); Note how serial is all lowercase. I have since compiled postgresql 7.0.2 on my friends box and installed it in my home directory so I could play w/ it. I was surprised when I couldn't build my table w/ the above statement, but if I were to do: create table blah ( id SERIAL ); (note how serial is all uppercase, now) it works. Can anyone explain why this happens? I guess for the time being, I'll capitalize every instance of 'serial' when I create tables, but this just got me curious. thanks!