Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 --- 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/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux