Re: Problem creating temporary tables . . .

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rubén Crespo Flores <ruben(dot)crespo1(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem creating temporary tables . . .
Date: 2012-09-19 21:30:18
Message-ID: 11992.1348090218@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= <ruben(dot)crespo1(at)gmail(dot)com> writes:
> Hi, I'm using PostgreSQL 9.0.4, with the replication activated to one server.
> About 3 weeks ago, we have a disk space problem on both servers. I recovered the DB but since then (or at least had not noticed before), in 10 executions of functions that generate temporary tables, 3 returns the following error message:

> ERROR: could not find tuple for attrdef 299038853
> SQL state: XX000
> Context: SQL statement "create temporary table tmp_tablatotlin15 (...

Hm ... that's a bit odd, but try reindexing pg_attrdef.

BTW, 9.0.4 is a bit old, you really ought to update to 9.0.latest.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Morton 2012-09-20 02:13:08 WAL File Volume
Previous Message Rubén Crespo Flores 2012-09-19 21:21:32 Problem creating temporary tables . . .