| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
| Cc: | "Chuck McDevitt" <cmcdevitt(at)greenplum(dot)com>, "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>, "beau hargis" <beauh(at)bluefrogmobile(dot)com>, pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Case Preservation disregarding case |
| Date: | 2006-11-02 15:51:25 |
| Message-ID: | 16897.1162482685@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> We have namespaces to differentiate between two sources of object names,
> so anybody who creates a schema where MyColumn is not the same thing as
> myColumn is not following sensible rules for conceptual distance.
I'd agree that that is not a good design practice, but the fact remains
that they *are* different per spec.
> Would be better to make this behaviour a userset
> switchable between the exactly compliant and the more intuitive.
That's certainly not happening --- if you make any changes in the
semantics of equality of type name, it would have to be frozen no
later than initdb time, for exactly the same reasons we freeze
locale then (hint: index ordering).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henry B. Hotz | 2006-11-02 18:17:53 | Re: Design Considerations for New Authentication Methods |
| Previous Message | Tom Lane | 2006-11-02 14:59:54 | Re: [PATCHES] Writing WAL for relcache invalidation:pg_internal.init |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anton P. Linevich | 2006-11-02 17:16:24 | Postgres-R |
| Previous Message | Andrew Sullivan | 2006-11-02 13:39:58 | Re: hi i am getting error...can u solve this |