Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.

 --- Tom Lane <tgl@sss.pgh.pa.us> escreveu: >
> It's fairly unlikely that that is the solution you need.  How often do
> you vacuum this table?

A vacuum is executed every tree hours to the whole database after it is updated
with more than 300.000 inserts and deletes.

>  Does it participate in any foreign keys, or do
> you have any user-defined triggers on it?

It participates in two foreign keys. No ud triggers on it.

> > backend> reindex database KakaoStats
> > ERROR:  REINDEX DATABASE: Can be executed only on the currently open
> database.
>
> Double quotes would help here.
>
I will try it.


______________________________________________________________________

Yahoo! Messenger - Fale com seus amigos online. Instale agora!
http://br.download.yahoo.com/messenger/