From: | Brian Hirt <bhirt(at)mobygames(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | failed to re-find parent key in "..." for deletion target page |
Date: | 2007-08-04 21:09:16 |
Message-ID: | AE971354-1343-45FE-8B6E-BCD771BCED40@mobygames.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I was doing some testing with tsearch2 on my dev box and I've run
across this problem.
I created the tsvector and added the trigger and then i was updating
the entire table to populate the ixdfti field. When i was done, I
was unable to vacuum the table, I get this error. Any ideas an
what's going on? I've shutdown the database and made a tar of it
incase there is additional info you need.
basement_dev=# update developer_name set developer_id = developer_id;
UPDATE 262083
basement_dev=# VACUUM FULL developer_name;
ERROR: failed to re-find parent key in
"developer_name_developer_name" for deletion target page 163
basement_dev=# \d developer_name;
Table
"public.developer_name"
Column | Type
| Modifiers
-------------------+------------------------
+-----------------------------------------------------------------------
-----
developer_name_id | integer | not null default nextval
('developer_name_developer_name_id_seq'::regclass)
developer_id | integer | not null
developer_name | character varying(255) | not null
idxfti | tsvector |
t | text |
idxfti2 | tsvector |
Indexes:
"developer_name_pkey" PRIMARY KEY, btree (developer_name_id)
"developer_name_developer_id" btree (developer_id)
"developer_name_developer_name" btree (developer_name)
Triggers:
tsvectorupdate BEFORE INSERT OR UPDATE ON developer_name FOR
EACH ROW EXECUTE PROCEDURE tsearch2('idxfti', 'developer_name')
basement_dev=# select version();
version
------------------------------------------------------------------------
----------------------------------------------------------------
PostgreSQL 8.2.4 on i386-apple-darwin8.9.1, compiled by GCC i686-
apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5341)
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Lamia Jackson | 2007-08-04 22:13:03 | BUG #3512: buggy install + no manual support |
Previous Message | Decibel! | 2007-08-04 17:01:15 | Re: Oddities with ANYARRAY |