case sensitive db name?
| От | Thomas Finneid |
|---|---|
| Тема | case sensitive db name? |
| Дата | |
| Msg-id | 4989EDA9.7060301@fcon.no обсуждение исходный текст |
| Ответы |
Re: case sensitive db name?
|
| Список | pgsql-general |
I have a case sensitivity problem I dont understand. On a Solaris 10 with pg 8.2.6 (Sun build) I get problems when I do a CREATE DATABASE with a db name with case. On a Kubuntu machine with pg 8.2.7 it is not a problem. More specifically the problem arises after the CREATE DATABASE, it occurs when I try to connect to the newly created database. The script is as follows, execute with the command $ psql -U postgres -f create_db.sql # create_db.sql script start \c postgres create database Test1; ... create user etc... \c Test1 user1 .... #Script end at the connect command the script fails. when I list the databases, it shows the db name with small letters, as in: "test1" instead of "Test1" Why is this a problem on one installation but not another? and how can I fix the solaris installation? regards thomas
В списке pgsql-general по дате отправления: