Bengt Månsson <name@some.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
