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

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