RE: Fwd: Problems inserting data

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: Fwd: Problems inserting data
Дата
Msg-id EKEJJICOHDIEMGPNIFIJOEGACEAA.Inoue@tpf.co.jp
обсуждение исходный текст
Ответ на Fwd: Problems inserting data  (Denis Perchine <dyp@perchine.com>)
Список pgsql-hackers
> -----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 tryselect 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andreas Degert
Дата:
Сообщение: Re: like-operator on index-scan
Следующее
От: Alfred Perlstein
Дата:
Сообщение: argh! NOTICE: Rel webhit_details_formatted: TID 7/17: OID IS INVALID. TUPGONE 0.