7.2, JDBC, and case sensitive names

Started by Robert Bergerabout 24 years ago3 messagesgeneral
Jump to latest
#1Robert Berger
rwb@vtiscan.com

I upgraded from 7.1 to 7.2 and now my java application is failing
because unquoted table names now seem to be case sensitive. Is this
a change in PostreSQL behavior or a change in the JDBC driver? Why
was it done?

#2Barry Lind
barry@xythos.com
In reply to: Robert Berger (#1)
Re: 7.2, JDBC, and case sensitive names

Robert,

Can you give an example or test case? I certainly am not seeing the
behavior you are describing on my 7.2 databases.

thanks,
--Barry

Robert Berger wrote:

Show quoted text

I upgraded from 7.1 to 7.2 and now my java application is failing
because unquoted table names now seem to be case sensitive. Is this
a change in PostreSQL behavior or a change in the JDBC driver? Why
was it done?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

#3Robert Berger
bob@bberger.net
In reply to: Barry Lind (#2)
Re: 7.2, JDBC, and case sensitive names

The change is in the JDBC driver calls that generate their own SQL,
such as Connection.getColumns(table)

It was easy enough to fix my code, but the unannounced change in
behavior was annoying.