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.
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 |