corrupted tables !!! - Mailing list pgsql-sql

From J.Fernando Moyano
Subject corrupted tables !!!
Date
Msg-id 01052610432703.01848@txino.mikasa.eh
Whole thread Raw
Responses Re: corrupted tables !!!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I have big problems with my postgres.
There is a table that gets corrupted frecuently !!! (every week ...)
I have to drop the table and create it again using the backup copy. (normally 
i lose some data)

Can it gets corrupted bucause of bad usage of transactions (ie. transactions 
not committed or rollbacked) ??

And an intensive usage of restrictions, foreign keys, etc... ???

Thanks !!


- -- 
Fernando Moyano

Frase del día:
- --------------
Linux es aburrido... con Windows nunca sabes cuándo se va a colgar.

(*) SymeX ==> http://symex.lantik.com
(*) WDBIL ==> http://wdbil.sourceforge.net
(*) Informate sobre LINUX en http://www.linux.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7D8EQoZaf9MvtDvcRArX0AKCmj7oqUaWsKi4245SKqeUEU2/QvwCcDY1L
sn48O86W3DRkSbnXJeqB/5U=
=XHJm
-----END PGP SIGNATURE-----


pgsql-sql by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: batch file
Next
From: Tom Lane
Date:
Subject: Re: corrupted tables !!!