Problem creating temporary tables . . .

Поиск
Список
Период
Сортировка
От Rubén Crespo Flores
Тема Problem creating temporary tables . . .
Дата
Msg-id 6F6C406D-518A-4E6F-ACE9-D234B6EB2418@gmail.com
обсуждение исходный текст
Ответы Re: Problem creating temporary tables . . .  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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
noticedbefore),  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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Michael Holt
Дата:
Сообщение: Re: max_locks_per_transaction and partitioned tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem creating temporary tables . . .