Hello,
I wrote this mail to pgsql-general, but have no mail from it since
yesterday. If someone replied to me, please resend the reply privately.
---------- Forwarded Message ----------
Subject: Problems inserting data
Date: Tue, 12 Sep 2000 17:02:57 +0700
From: Denis Perchine <dyp@perchine.com>
Hello,
I have really strange problem with insert.
It worked before...
Sep 12 04:48:34 mx postgres[25768]: DEBUG: query: insert into listmembers (server_id,email,name)
values(12836,'lan@technoart.net','LANIV')
Sep 12 04:48:34 mx postgres[25768]: ERROR: Index 13853499 does not exist
What does this error mean???
From the source code I can get that this mean that relation with this oid is
invalid, but problem is that I do not have such relation in pg_class.
webmailstation=> select * from pg_class where oid=13853499;relname | reltype | relowner | relam | relpages | reltuples
|rellongrelid | relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys |
relrefs| relhaspkey | relhasrules | relhassubclass | relacl
---------+---------+----------+-------+----------+-----------+--------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+-------------+----------------+--------
(0 rows)
And I can not found it in pg_index.
webmailstation=> select * from pg_index where indexrelid=13853499;indexrelid | indrelid | indproc | indkey | indclass |
indisclustered| indislossy | indhaskeytype | indisunique | indisprimary | indreference | indpred
------------+----------+---------+--------+----------+----------------+------------+---------------+-------------+--------------+--------------+---------
(0 rows)
I have rebuild indices for listmembers table, but this does not help.
Any thoughts of what is this can be?
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
-------------------------------------------------------
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
