Thread: help database corruption

hi guys
the database seems to corrupt .the messages are
intent to vacumm:

[postgres@defiant postgres]$ /usr/local/pgsql/bin/vacuumdb -a
Vacuuming EstacionVasconiaDevelop
ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
el directorio
vacuumdb: vacuum  EstacionVasconiaDevelop failed
[postgres@defiant postgres]$


backend messages
XLogFlush: request 0/109118E8 is not satisfied --- flushed only to 0/108EA9D8
ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
el directorio
ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
el directorio


explanation:
the applicatoin create the tmpturnos with
 select into tmpturnos from ....
the table tmpturnos does not exist for database if you try
create tmpturnos(...) refuse with databse already existsif try drop table tmpturnos  refuse with   database tmpturnos
notexists 
any ideas ? technical information
  linux mandrake 8.0   postgres version 7.3.1
best regards MDc





-------------------------------------------------
¿Todavía no navegás con Keko?
Hacé click aquí: http://www.keko.com.ar

On Wed, 7 May 2003 mdc@keko.com.ar wrote:

>  the database seems to corrupt .
>  the messages are
> intent to vacumm:
>
> [postgres@defiant postgres]$ /usr/local/pgsql/bin/vacuumdb -a
> Vacuuming EstacionVasconiaDevelop
> ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
> el directorio
> vacuumdb: vacuum  EstacionVasconiaDevelop failed
> [postgres@defiant postgres]$

Hmm, is there a pg_class entry for tmpturnos?  If so, is there actually a
file in the database directory with the name of its relfilenode?