| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: per-database locale: createdb switches |
| Date: | 2009-01-12 15:16:18 |
| Message-ID: | 496B5EC2.9020405@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian wrote:
> Heikki Linnakangas wrote:
>> Alvaro Herrera wrote:
>>> Tom Lane wrote:
>>>> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>>>>> Alvaro Herrera wrote:
>>>>>> I like Teodor's proposal; I'll see about implementing that.
>>>>> Attached.
>>>> You missed updating the sgml docs, and personally I'd be inclined to
>>>> list -l before the individual --lc switches; otherwise it looks fine.
>>> Thanks, committed that way. I noticed that --lc-ctype and --lc-collate
>>> were forgotten in SGML docs, so I added them too.
>> Should we have a shorthand CREATE DATABASE option like that as well?
>
> createdb is really about convenience; not sure it is warranted for
> CREATE DATABASE.
I think unless you are doing something completely funny, you would
usually want to have COLLATE and CTYPE equal. The fact that you now
have to enter both to get that result could be pretty annoying in
practice, I would think.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2009-01-12 15:21:25 | Re: Recovery Test Framework |
| Previous Message | Tom Lane | 2009-01-12 15:13:06 | Re: SET TRANSACTION and SQL Standard |