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','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@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
----------------------------------

Wed, 13 Sep 2000 18:07:56 +0700
Denis Perchine <dyp@perchine.com>
Fwd: Problems inserting data
> -----Original Message-----
> From: Denis Perchine
> 
> 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.
>

I don't have any mail from pgsql-general for 2 days either.
  
> 
> 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','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;

Could you try 
	select oid from pg_class;
and find an oid=13853499 entry ?

> 
> And I can not found it in pg_index.
> 
> webmailstation=> select * from pg_index where indexrelid=13853499;

Could you also try
	select indexrelid from pg_index;
and find an indexrelid=13853499 entry ?

If you could find such an entry,your system indexes may be broken.

Regards.

Hiroshi Inoue
	
 

Thu, 14 Sep 2000 06:17:32 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
RE: Fwd: Problems inserting data