| From: | Thomas Finneid <tfinneid(at)fcon(dot)no> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | case sensitive db name? |
| Date: | 2009-02-04 19:34:01 |
| Message-ID: | 4989EDA9.7060301@fcon.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anderson dos Santos Donda | 2009-02-04 20:05:10 | SELECT on a table with Time values |
| Previous Message | Merlin Moncure | 2009-02-04 19:31:36 | Re: Pet Peeves? |