Fwd: Problems inserting data
От | Denis Perchine |
---|---|
Тема | Fwd: Problems inserting data |
Дата | |
Msg-id | 0009131808590A.27833@dyp.perchine.com обсуждение исходный текст |
Ответы |
RE: Fwd: Problems inserting data
|
Список | pgsql-hackers |
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 ----------------------------------
В списке pgsql-hackers по дате отправления: