| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Paul Simpson <Paul(dot)Simpson(at)spgs(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why does app fail? |
| Date: | 2004-02-25 15:54:38 |
| Message-ID: | 20040225074844.I26223@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 25 Feb 2004, Paul Simpson wrote:
> I have downloaded it, thanks.
> I'm not sure about this "foldtoupper" idea (particularly as they are
> also talking about leaving the tablenames alone in the system tables.
>
> What I don't understand is why the system can't be told simply to be
> case sensitive. That way, if a table is created as MyTaBlE then it is
> called MyTaBlE without requiring quotes, or am I missing something here?
It could, but I think that'd be even further from spec complience than
what we do now (fold to lowercase). Foldtoupper should provide a setting
that is not backward compatible with postgresql versions but meets the SQL
spec for handling unquoted names.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Alkins | 2004-02-25 16:03:28 | Re: [PHP] phpBB 2.2 and PostgreSQL support |
| Previous Message | cnliou | 2004-02-25 15:49:19 | Re: TG_RELNAME problem |