Re: [GENERAL] problem of upper/lower case in table names
От | Jay O'Connor |
---|---|
Тема | Re: [GENERAL] problem of upper/lower case in table names |
Дата | |
Msg-id | 9811171425400E.00469@localhost.localdomain обсуждение исходный текст |
Ответ на | problem of upper/lower case in table names (Charles-Edouard Ruault <cruault@planetweb.com>) |
Ответы |
RE: [GENERAL] problem of upper/lower case in table names
|
Список | pgsql-general |
>Hi all, > >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 I've run into the same problem just creating a table with a name including an uppercase. The name gets converted to all lowercase but then I seem unable to DROP the table. >NB : i'm using postgres 6.4 with jdbc driver included in this release. -- Jay O'Connor joconnor@roadrunner.com http://www.roadrunner.com/~joconnor "God himself plays the bass strings first when He tunes the soul"
В списке pgsql-general по дате отправления: