Re: PostgreSQL; Strange error

Bengt Månsson <name(at)some(dot)site> wrote:
>I use RH7, Apache, PHP4 and PostgreSQL

Your problem is a RDBMS problem, not a WWW server one. The PostgreSQL
mailing lists (see http://www.postgresql.org/users-lounge/index.html) are a
better place to ask.

>Warning: PostgreSQL query failed: FATAL 1: my bits moved right off the end
>of the world! Recreate index pg_attribute_relid_attnum_index.

>I don't understand any of this. Never heard of that index.

It starts with "pg_", so it's Postgres' meta-data (internal administration).

>What does it mean?

Apparently one of Postgres' internal indexes got corrupted.

> What can I do?

Follow the suggestion given in the warning: recreate index
pg_attribute_relid_attnum_index, presumably [*] using something like

DROP INDEX pg_attribute_relid_attnum_index;
CREATE UNIQUE INDEX pg_attribute_relid_attnum_index ON
pg_attribute(attrelid,attnum);

(as database user 'postgres').

HTH,
Ray

[*] I'm just guessing from '\d pg_attribute_relid_attnum_index' and '\d
pg_attribute' - back up your database (using "pg_dump") before trying this.
--
Think of computer security like powertools. The day you think you are
totally safe is the day you end up hurt.
Alan Cox