Skip site navigation (1) Skip section navigation (2)

Re: JDBC bug?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Nate Gelbard <gelbardn(at)tripwire(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC bug?
Date: 2001-11-26 18:30:24
Message-ID: 200111261830.fAQIUOH29986@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
> Hi,
> 
> I've found an annoyance with the postgresql JDBC driver (from the 7.1.3 
> release).
> 
> Pardon if this has been asked before, but the web archives are offline...
> 
> In org/postgresql/jdbc2/DatabaseMetaData.java, there are several lines
> that call toLowerCase() on the table string names. This causes 'table 
> unknown' erros when accessing tables with mixed case in the name. This 
> popped out at me when trying to use the XML-DBMS package and also 
> DbVisualizer.
> 
> Also, when using the pgsql shell, \d createdBy returns table unknown, 
> but \d "createBy" returns the right info.
> 
> So does postgres not support mixed case in table names, or the backend 
> does but the clients dont, or what?

Well, we support mixed case identifiers, but they need to be
double-quoted, as you saw.  The \d behavior looks correct.  The jdbc
issue looks more complicated because we are forcing lowercase in the
jdbc code.  Perhaps some jdbc folks can comment on that.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

  • JDBC bug? at 2001-11-26 18:00:32 from Nate Gelbard

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2001-11-26 18:33:20
Subject: Re: CallableStatements
Previous:From: Nate GelbardDate: 2001-11-26 18:00:32
Subject: JDBC bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group