Problems inserting data

From: Denis Perchine <dyp(at)perchine(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems inserting data
Date: 2000-09-12 10:02:57
Message-ID: 0009121707400W.16202@dyp.perchine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)technoart(dot)net','LAN IV')
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(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2000-09-12 11:19:04 Re: Transaction Manager
Previous Message Evgeni E. Selkov 2000-09-12 08:19:16 Re: How to display a user-defined function? (2nd attempt)