Ian FREISLICH <if@xxxxxxxxxxxxx> writes: > I ran into this little astonishment yesterday on 7.4.8. When I > create a database connected as the super user using: > CREATE DATABASE foo OWNER = foo; > The database is indeed owned by user foo, but the automatically > created public schema is is owned by the database super user. Should > this schema not be created as owned by the database owner specified > in the CREATE DATABASE command? That's the way it's supposed to work. CREATE DATABASE does not change anything inside the copied database. regards, tom lane
