From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Denis Perchine" <dyp(at)perchine(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: Fwd: Problems inserting data |
Date: | 2000-09-13 21:17:32 |
Message-ID: | EKEJJICOHDIEMGPNIFIJOEGACEAA.Inoue@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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;
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2000-09-13 23:28:04 | argh! NOTICE: Rel webhit_details_formatted: TID 7/17: OID IS INVALID. TUPGONE 0. |
Previous Message | Andreas Degert | 2000-09-13 20:51:37 | Re: like-operator on index-scan |