BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres

Поиск
Список
Период
Сортировка
Искать
От
xelah-postgresql@xelah.com
Тема
BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres
Дата
Msg-id
20151124121258.435.64678@wrigleys.postgresql.org
Список
Дерево обсуждения
BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres xelah-postgresql@xelah.com
Re: BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres Bruce Momjian <bruce@momjian.us>
Re: BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres "David G. Johnston" <david.g.johnston@gmail.com>
Re: BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres "David G. Johnston" <david.g.johnston@gmail.com>
Re: BUG #13783: 'create database test owner testowner' as 'postgres' leaves test.public owned by postgres Pedro Gimeno <pgsql-004@personal.formauri.es>
The following bug has been logged on the website:

Bug reference:      13783
Logged by:          Alex Hayward
Email address:      xelah-postgresql@xelah.com
PostgreSQL version: 9.4.5
Operating system:   Debian 8.2
Description:        

'CREATE DATABASE .. OWNER ..' creates a database owned by the correct user,
but containing a schema apparently owned by the user running 'CREATE
DATABASE'. This causes us a problem when our test code tries to 'DROP SCHEMA
public CASCADE' (as a way of clearing the database) as the database owner.

example:

PGHOST=127.0.0.1 psql template1 postgres                                    
                          
Password for user postgres:                               
psql (9.4.5)    
Type "help" for help.          
template1=# create user test;
CREATE ROLE      
template1=# create database test owner test; 
CREATE DATABASE
template1=# \c test
You are now connected to database "test" as user "postgres".
test=# \dn 
  List of schemas
  Name  |  Owner 
--------+----------                     
 public | postgres 
(1 row)   
test=#
В списке pgsql-bugs по дате отправления
От: pinker
Дата:
От: David G. Johnston
Дата:
FAQ