Skip site navigation (1) Skip section navigation (2)

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

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: "Jay W(dot) Summet" <jay(at)summet(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)
Date: 1999-03-26 03:35:51
Message-ID: (view raw, whole thread or download thread mbox)
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 @ 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 

In response to

pgsql-general by date

Next:From: The Hermit HackerDate: 1999-03-26 03:37:06
Subject: RE: [GENERAL] info on people running postgre
Previous:From: Jim JennisDate: 1999-03-25 22:48:36
Subject: Re: [GENERAL] Re: [SQL] sql 92 support in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group