corrupted tables !!!

From: "J(dot)Fernando Moyano" <txinete(at)wanadoo(dot)es>
To: pgsql-sql(at)postgresql(dot)org
Subject: corrupted tables !!!
Date: 2001-05-26 14:43:27
Message-ID: 01052610432703.01848@txino.mikasa.eh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-05-26 14:53:56 Re: corrupted tables !!!
Previous Message Madness 2001-05-26 10:48:45 altering date type of a column