Обсуждение: 7.2, JDBC, and case sensitive names

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?

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:

> 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
>

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.