Horton

Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)

Marc G. Fournier <scrappy@hub.org>

View thread View on postgr.es
From: The Hermit Hacker <scrappy@hub.org>
To: "Jay W. Summet" <jay@summet.com>
Cc: pgsql-general@postgreSQL.org
Date: 1999-03-26T03:35:51Z
Lists: pgsql-general 
On Thu, 25 Mar 1999, Jay W. Summet wrote:

> When I try to vacuum, or vacuum analyze my database, I get the 
> following error:
> FATAL 1:btree: BTP_CHAIN flag was expected
> 
> I've tried the following two commands:
> /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing
> and
> /usr/local/pgsql/bin/psql -c "vacuum;" billing
> 
> The top command used to work (for the last few years), so I assume 
> that something has changed with my data. Otherwise, the database 
> appears to be working ok.
> 
> Any pointers? I'm thinking about dumping all the data and 
> re-inserting it...

Try just drop'ng and rebuilding your indices...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org