Ynt: corrupted tables !!!
От | Madness |
---|---|
Тема | Ynt: corrupted tables !!! |
Дата | |
Msg-id | 9envsu$2b8b$1@news.tht.net обсуждение исходный текст |
Ответ на | corrupted tables !!! ("J.Fernando Moyano" <txinete@wanadoo.es>) |
Список | pgsql-sql |
Hi, What kind of a corruption? Do you lose data? As far as I tested; bas transactions do not destroy db. With regards, Devrim "J.Fernando Moyano" <txinete@wanadoo.es> wrote in message news:01052610432703.01848@txino.mikasa.eh... > -----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----- > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
В списке pgsql-sql по дате отправления: