Re: [HACKERS] Re: [GENERAL] Variable case database names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: prlw1(at)cam(dot)ac(dot)uk, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Re: [GENERAL] Variable case database names
Date: 2000-01-20 22:51:43
Message-ID: 25186.948408703@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> There is some code in libpq which converts all database names to
> lower-case, unless it's double quoted. That seems a little ill-conceived
> to me,

I think you are probably right. The backend might try to lowercase the
name when it gets it, but it seems like libpq shouldn't be doing so
(any more than it's responsible for downcasing identifiers used in
SQL commands).

If the backend *does* lowercase the DB name used in a connect command,
is there any way to use a mixed-case DB name? I'm not sure there is...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sarah Officer 2000-01-20 22:56:24 < and > for datetime
Previous Message Jim Mercer 2000-01-20 22:40:44 Re: [GENERAL] Unsigned Datatypes

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-01-20 22:54:20 Re: [HACKERS] Status on 7.0
Previous Message Tom Lane 2000-01-20 22:46:37 Re: [HACKERS] off topic