From: | Zeljko Trogrlic <zeljko(at)post(dot)hinet(dot)hr> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, Zeljko Trogrlic <zeljko(at)technologist(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Column name case conversion |
Date: | 2000-09-11 16:39:35 |
Message-ID: | 4.1.20000911183643.018c4b28@192.168.0.7 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Look at the Interbase solution: they have so called "dialects". Dialect 1
is currently old Interbase 5.x and older. Dialect 2 is intermediate dialect
for easier transition. Dialect 3 is Interbase 6 dialect. They did some
pretty nasty changes between 1 and 3, but you can select in client (ODBC
driver etc.) which dialect you'll use.
>> Compatibility could be solved with compatibility flags. I guess this is not
>> the only place where PostgreSQL breaks compatibility (like any other
>database).
>
>I was more thinking about backwards compatibility.
>I guess you could switch forward by having the database have two name
>columns, one for the search name (lowercased) and one for the "real"
>name. Then you'd need a hack that would lowercase the real name of
>the identifier if you had a quoted and unquoted version with the
>same case.
>Cases such as ID, "id" would be failures (duplicate identifier) just like
>it is now, Cases such as "ID", id would work (the quoted one also only
>matches to "ID") and cases such as "ID", ID are the same as it is now.
v
Zeljko Trogrlic
____________________________________________________________
Aeris d.o.o.
Sv. Petka 60 b, HR-31000 Osijek, Croatia
Tel: +385 (31) 53 00 15
Email: mailto:zeljko(at)post(dot)hinet(dot)hr
From | Date | Subject | |
---|---|---|---|
Next Message | Gary MacDougall | 2000-09-11 16:58:57 | Re: Transaction Manager |
Previous Message | Stephan Szabo | 2000-09-11 16:37:42 | Re: Removing all NOT NULL constraints from multiple tables easily |