Radek Strnad escribió:
> - when creating database with different collation than database cluster, the
> database has to be reindexed. Any idea how to do it? Function
> ReindexDatabase works only when database is opened.
We have this Todo item:
Set proper permissions on non-system schemas during db creation Currently all schemas are owned by the super-user
becausethey are copied from the template1 database. However, since all objects are inherited from the template
database,it is not clear that setting schemas to the db owner is correct.
When this was discussed years ago, one proposed idea was that on the
first connection the backend should, as a first task, ensure that
certain administrative chores be done. The first of those was changing
the ownership of schemas. It sounds like this reindexing you propose
falls into the same category.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support