Received: from ns.mt.sri.com (ns.mt.sri.com [206.127.79.91] (may be forged))
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9UKH5C10938
	for <pgsql-interfaces@postgresql.org>;
	Mon, 30 Oct 2000 15:17:06 -0500 (EST)
	(envelope-from chris@mt.sri.com)
Received: from merry.mt.sri.com (merry.mt.sri.com [206.127.76.99])
	by ns.mt.sri.com (8.9.3/8.9.3) with ESMTP id NAA06538;
	Mon, 30 Oct 2000 13:16:59 -0700 (MST)
	(envelope-from chris@mt.sri.com)
Received: (from chris@localhost)
	by merry.mt.sri.com (8.11.0/8.11.0) id e9UKGvi09460;
	Mon, 30 Oct 2000 13:16:57 -0700 (MST)
X-Authentication-Warning: merry.mt.sri.com: chris set sender to
	chris@mt.sri.com using -f
To: pgsql-interfaces@postgresql.org
Cc: peter@retep.org.uk
Subject: PG JDBC bug?
X-Attribution: Jones
From: Chris Jones <chris@mt.sri.com>
Date: 30 Oct 2000 13:16:51 -0700
Message-ID: <a5f4s1u5bkc.fsf@merry.mt.sri.com>
Lines: 17
User-Agent: Gnus/5.0807 (Gnus v5.8.7) Emacs/20.7
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200010/10
X-Sequence-Number: 10

Hi--

I'm using the JDBC driver that came with my pg-7.0.2, and I'm also
playing with Sun's J2EE SDK.  Apparently, when the SDK tries to create
tables, it looks at the DatabaseMetaData from the driver Connection,
searching for an appropriate text type.  The first one it finds is
NAME, which doesn't seem quite right.

The PostgreSQL manual says that NAME is really only supposed to be
used for internal purposes; if that's the case, then shouldn't
getTypes() say that NAME is OTHER, instead of VARCHAR?

Chris

-- 
----------------------------------------------------- chris@mt.sri.com
Chris Jones                                    SRI International, Inc.