Re: could not open relation No such file or directory after alter table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris <pglist(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: could not open relation No such file or directory after alter table
Date: 2005-01-10 13:57:53
Message-ID: 11314.1105365473@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris <pglist(at)gmail(dot)com> writes:
> This is Postgresql 8 RC 1 on freebsd 5.3.
> I changed the type of a column from varchar(128) to varchar(256), and
> right after that I got the following messages when doing inserts on
> the table in question.

> <41e0e2c3.fd54>ERROR: SMgrRelation hashtable corrupted
> <41e0e2c3.fd54>STATEMENT: commit

Hmm. We got another report of that back in September, but AFAICS from
the archives it was never resolved because we couldn't reproduce it.
Can you come up with a reproducible test case?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2005-01-10 13:58:24 Re: Problem creating trigger-function with arguments (8.0rc4)
Previous Message Tom Lane 2005-01-10 13:39:50 Re: ORDER BY in UNION query