Your message dated Tue, 12 Feb 2013 16:15:46 +0100
with message-id <[email protected]>
and subject line Re: [Pkg-postgresql-public] Bug#700271: postgresql-9.1:
non-obvious choice of database locale
has caused the Debian Bug report #700271,
regarding postgresql-9.1: non-obvious choice of database locale
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
700271: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=700271
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-9.1
Version: 9.1.7-1
Severity: wishlist
I am a fairly novice postgresql user, so I was just installing
postgresql-9.1 without any knowledge about database locale and how it
can go wrong. The installation procedure determined that LATIN1 would be
a perfect choice for my system, which lead to a number of problems later
on.
Given the number of issues that arise when using a non-UTF8 locale for
databases I suggest defaulting the locale to UTF8 and ignoring
environment variables used during installation and/or creating a
priority low debconf prompt for this.
Here is a list of problems which seem related.
#660209
#699453
https://www.blog.akendo.eu/debian-postgresql-8-4-cant-create-database-with-utf-8-encoding/
http://jacobian.org/writing/pg-encoding-ubuntu/
Feel free to disagree with me. In that case wontfix is your tag.
Helmut
--- End Message ---
--- Begin Message ---
tag 700271 wontfix
thanks
Hello Helmut,
Helmut Grohne [2013-02-10 19:35 +0100]:
> I am a fairly novice postgresql user, so I was just installing
> postgresql-9.1 without any knowledge about database locale and how it
> can go wrong. The installation procedure determined that LATIN1 would be
> a perfect choice for my system, which lead to a number of problems later
> on.
I seem to remember that this was because your system locale was in
fact a latin1 one, so the default was correct.
> Given the number of issues that arise when using a non-UTF8 locale for
> databases I suggest defaulting the locale to UTF8 and ignoring
> environment variables used during installation and/or creating a
> priority low debconf prompt for this.
I think defaulting to an encoding which doesn't match the system
locale is a rather bad idea, as that will cause even more problems
(like unexpected sorting or unreadable log messages).
You are right in the sense that non-UTF8 locales lead to a lot of
unexpected problems these days. I strongly recommend using an UTF-8
locale on your system.
So I respectfully "wontfix"/close this bug.
Thank you!
Martin
--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
signature.asc
Description: Digital signature
--- End Message ---
