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: (view raw or whole 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/, 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                        |
  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


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-2015 The PostgreSQL Global Development Group