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

From: Clodoaldo Pinto Neto <clodoaldo_pinto(at)yahoo(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
Date: 2004-04-12 03:02:16
Message-ID: 20040412030216.84003.qmail@web40906.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug Dalton 2004-04-12 03:25:03 Installing postgres
Previous Message Ericson Smith 2004-04-12 02:48:05 Re: Large DB