Skip site navigation (1) Skip section navigation (2)

Re: WIP patch: Collation support

From: "Radek Strnad" <radek(dot)strnad(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP patch: Collation support
Date: 2008-09-01 09:01:39
Message-ID: de5165440809010201q24129262v807adef65b613752@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Ok, so do you suggest to leave it with a notice "reindex database" or start
to solve it somehow?

Regards

Radek Strnad

On Mon, Sep 1, 2008 at 12:08 AM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com>wrote:

> 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 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
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

In response to

Responses

pgsql-hackers by date

Next:From: Pavel StehuleDate: 2008-09-01 09:15:56
Subject: Re: Is this really really as designed or defined in some standard
Previous:From: Magnus HaganderDate: 2008-09-01 07:53:06
Subject: Re: Is this really really as designed or defined in some standard

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group