Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TERqh-0005Hq-5V for pgsql-admin@postgresql.org; Wed, 19 Sep 2012 21:30:23 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TERqe-0003Yv-EM for pgsql-admin@postgresql.org; Wed, 19 Sep 2012 21:30:22 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q8JLUILg011993; Wed, 19 Sep 2012 17:30:19 -0400 (EDT) From: Tom Lane To: =?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= cc: pgsql-admin@postgresql.org Subject: Re: Problem creating temporary tables . . . In-reply-to: <6F6C406D-518A-4E6F-ACE9-D234B6EB2418@gmail.com> References: <6F6C406D-518A-4E6F-ACE9-D234B6EB2418@gmail.com> Comments: In-reply-to =?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= message dated "Wed, 19 Sep 2012 16:21:32 -0500" Date: Wed, 19 Sep 2012 17:30:18 -0400 Message-ID: <11992.1348090218@sss.pgh.pa.us> X-Pg-Spam-Score: -2.5 (--) X-Archive-Number: 201209/109 X-Sequence-Number: 40050 =?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= 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