Yep.But this is a little strange ,maybe we should ask to change it?
Evgeny.
Tom Lane wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
