Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)
- From: The Hermit Hacker <scrappy(at)hub(dot)org>
- To: "Jay W. 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: Thu, 25 Mar 1999 23:35:51 -0400 (AST)
- Message-id: <Pine.BSF.4.05.9903252335330.389-100000@thelab.hub.org> <text/plain>
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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
- References:
- FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)
- From: Jay W. Summet
- FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)
- Prev by Date: Re: [GENERAL] Re: [SQL] sql 92 support in postgres
- Next by Date: RE: [GENERAL] info on people running postgre
- Previous by thread: FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)
- Next by thread: Macintosh Drivers
- Indexes: