Yep.But this is a little strange ,maybe we should ask to change it?
Evgeny.
Tom Lane wrote:
Ian FREISLICH <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
