Received: from id.godlike.com (id.godlike.com [206.205.199.129])
	by hub.org (8.9.1/8.9.1) with ESMTP id QAA00375
	for <pgsql-general@postgreSQL.org>;
	Tue, 17 Nov 1998 16:55:34 -0500 (EST)
	(envelope-from taral@cyberjunkie.com)
Received: from taral ([208.247.20.138])
	by id.godlike.com (8.8.5/8.8.5) with SMTP id QAA24751;
	Tue, 17 Nov 1998 16:55:22 -0500 (EST)
From: "Taral" <taral@cyberjunkie.com>
To: "Jay O'Connor" <joconnor@roadrunner.com>, <pgsql-general@postgreSQL.org>
Subject: RE: [GENERAL] problem of upper/lower case in table names
Date: Tue, 17 Nov 1998 15:55:22 -0600
Message-ID: <001001be1274$f9b2bf20$8a14f7d0@taral.dobiecenter.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
In-Reply-To: <9811171425400E.00469@localhost.localdomain>

> >i've got this annoying problem : if you create a table with an uppercase
> >name, postgres transforms it in lower case. After that, if you try to
> >retrieve the primary keys for this table ( still using the uppercase
> >name as argument ) using the JDBC driver
> >DatabaseMetaData.getPrimaryKeys(), it always return an empty result set
> >since the SQL command used in the driver requests a case sensitive match
> >for the table name ( and bc.relname ~ table ).
> >I've a workaround in the driver ( using bc.relname ~* table ) but i'd
> >like to know who's fault it is ( mine or postgres ) ....
> >Thanks for your advices & help

Try quoting the names... i.e. CREATE TABLE "TEST" etc.

Taral