Ok, so do you suggest to leave it with a notice "reindex database" or start
to solve it somehow?
On Mon, Sep 1, 2008 at 12:08 AM, Alvaro Herrera
> Radek Strnad escribió:
> > - when creating database with different collation than database cluster,
> > 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 because they 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
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-hackers by date
|Next:||From: Pavel Stehule||Date: 2008-09-01 09:15:56|
|Subject: Re: Is this really really as designed or defined in some standard|
|Previous:||From: Magnus Hagander||Date: 2008-09-01 07:53:06|
|Subject: Re: Is this really really as designed or defined in some