Re: [ADMIN] Problem creating temporary tables . . .

2012-09-20 Thread Tom Lane
=?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= writes: > El 20/09/2012, a las 12:36, Tom Lane escribió: >> There's something awfully odd about that. A look in the 9.0 sources >> says that that specific error text only appears in RemoveAttrDefault >> and getObjectDescription - and the latter is only used

Re: [ADMIN] Problem creating temporary tables . . .

2012-09-20 Thread Rubén Crespo Flores
El 20/09/2012, a las 12:36, Tom Lane escribió: > =?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= writes: 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 reindexi

Re: [ADMIN] Problem creating temporary tables . . .

2012-09-20 Thread Tom Lane
=?iso-8859-1?Q?Rub=E9n_Crespo_Flores?= writes: >>> 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. > I tried reindexing pg_attrdef and pg_at

Re: [ADMIN] Problem creating temporary tables . . .

2012-09-19 Thread Tom Lane
=?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 funct

[ADMIN] Problem creating temporary tables . . .

2012-09-19 Thread Rubén Crespo Flores
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 foll