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