Michael Monnerie wrote:
> On Mittwoch 17 Dezember 2008 Michael Monnerie wrote:
> > for each and every delete of a row in that table. After a
> > REINDEX TABLE dbmail_messageblks;
> > everything seems to work.
> I was wrong, still get this error:
> Dec 18 10:55:33 db2.zmi.at postgres: [112-1] DELETE:ERROR: could
> not open relation with OID 102021
> Dec 18 10:55:33 db2.zmi.at postgres: [112-2] DELETE:CONTEXT: SQL
> statement "DELETE FROM ONLY "public"."dbmail_messageblks"
Does it persist if you close the connection and open a new one?
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-admin by date
|Next:||From: Stefano Nichele||Date: 2008-12-18 13:02:02|
|Subject: tracking last_autovacuum|
|Previous:||From: Michael Monnerie||Date: 2008-12-18 10:23:11|
|Subject: Re: DROP INDEX causes errors|