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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Clodoaldo Pinto Neto <clodoaldo_pinto(at)yahoo(dot)com(dot)br>
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 02:23:32
Message-ID: 28168.1081736612@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <clodoaldo_pinto(at)yahoo(dot)com(dot)br> writes:
> I suspect there is something wrong because it takes 73s to delete a single line
> from a table whith 140 lines. So I tried to reindex the database:

It's fairly unlikely that that is the solution you need. How often do
you vacuum this table? Does it participate in any foreign keys, or do
you have any user-defined triggers on it?

> backend> reindex database KakaoStats
> ERROR: REINDEX DATABASE: Can be executed only on the currently open database.

Double quotes would help here.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-04-12 02:24:54 Re: pg_ctl written in c
Previous Message Edmund Dengler 2004-04-12 02:05:58 REINDEX slow?