Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ruben.crespo1@gmail.com>) id 1TERiE-0001HT-VB
	for pgsql-admin@postgresql.org; Wed, 19 Sep 2012 21:21:39 +0000
Received: from mail-yx0-f174.google.com ([209.85.213.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ruben.crespo1@gmail.com>) id 1TERiD-000768-Dj
	for pgsql-admin@postgresql.org; Wed, 19 Sep 2012 21:21:38 +0000
Received: by yenm12 with SMTP id m12so266276yen.19
	for <pgsql-admin@postgresql.org>; Wed, 19 Sep 2012 14:21:36 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=from:content-type:content-transfer-encoding:subject:date:message-id
	:to:mime-version:x-mailer;
	bh=rdvgDJgTy6Ssqk2bVTotYdJ8d+cVxvLm1p/AK6DMJT0=;
	b=KvPXWqeQFLM+dPGXpzrXJ19YFE6yAGIdtVsqNataBrcN14iaSn/sji0NgF9QxakpB1
	es7P13fkZDRNzxn6LNRn/EOA0c1mHxItLIR692c9Mp0aECDRZLQlybYmgCgffnCFkXTm
	3KIJwoOMLrnvCphT87OQC+1yCO14AFPvOYPhc2YwMyccNrESAIVnSj9ac8E5Djqap9xd
	HiMZotqOwNXWueaYcsbbkawYVjz4ZSW4P7BfrBiDb42pC00wV72F7igdSl6syKo23LHk
	PLZxN7TJ7qUoBlUscLKR4un9h9Yggy0kNKVzN9f85pi3wVd6svHoQWcz0Qk10+g4lBSd
	sInA==
Received: by 10.100.84.3 with SMTP id h3mr1531770anb.56.1348089696582;
	Wed, 19 Sep 2012 14:21:36 -0700 (PDT)
Received: from [192.168.1.104] ([200.76.1.140])
	by mx.google.com with ESMTPS id k2sm4003649anl.11.2012.09.19.14.21.35
	(version=TLSv1/SSLv3 cipher=OTHER);
	Wed, 19 Sep 2012 14:21:35 -0700 (PDT)
From: =?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= <ruben.crespo1@gmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: Problem creating temporary tables . . .
Date: Wed, 19 Sep 2012 16:21:32 -0500
Message-Id: <6F6C406D-518A-4E6F-ACE9-D234B6EB2418@gmail.com>
To: pgsql-admin@postgresql.org
Mime-Version: 1.0 (Apple Message framework v1251.1)
X-Mailer: Apple Mail (2.1251.1)
X-Pg-Spam-Score: -2.3 (--)
X-Archive-Number: 201209/108
X-Sequence-Number: 40049

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 (...

We apply vaccum analize to pg_class, pg_attribute, pg_attrdef and =
pg_depends, but did not help much.

I appreciate your attention. Any suggestions are welcome.

regards and thanks