BUG #5345: non-administrator users cannot create databases with special encoding

From: "Zoltan Kovacs" <kovzol(at)particio(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5345: non-administrator users cannot create databases with special encoding
Date: 2010-02-24 10:30:22
Message-ID: 201002241030.o1OAUMgY003857@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5345
Logged by: Zoltan Kovacs
Email address: kovzol(at)particio(dot)com
PostgreSQL version: 8.3.9-0lenny1
Operating system: Debian Linux 5.0.4
Description: non-administrator users cannot create databases with
special encoding
Details:

I would like to create a database using SQL_ASCII encoding, but it is not
allowed for a normal user, only for the postgres user.

Details (sorry, it is partially in Hungarian):

postgres=# create user wmi2user with password 'wmi2pass' createdb
nocreateuser;
CREATE ROLE
...
postgres(at)wmi:~$ psql -l
Adatbázisok listája
Név | Tulajdonos | Kódolás
-----------+------------+-----------
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
wmi | postgres | SQL_ASCII
(4 rows)

postgres(at)wmi:~$ createdb -E SQL_ASCII -U wmi2user wmi2db
createdb: database creation failed: ERROR: encoding SQL_ASCII does not
match server's locale hu_HU.UTF-8
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.

postgres(at)wmi:~$ createdb -E SQL_ASCII wmi2db

The last command line was successful.

Summarizing: The operation is allowed for the administrator, but not for a
normal user. But I would like to create this database by a normal user.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Oleg Serov 2010-02-24 12:12:59 Re: BUG #5314: Error in nested composite types in plpgsql.
Previous Message Pavel Stehule 2010-02-24 07:06:39 Re: RETURNS TABLE returns NULL set when called by another RETURNS TABLE