I'm having problems with transactions, lately. I'm checking power-failure conditions on my psql-based programs, and found that a simple loop with
BEGIN TRANSACTION
INSERT INTO test VALUES('any #n');
COMMIT TRANSACTION
leaves me with no records inserted at all after an abrupt reset on the server. The loop is outside the transaction, id est, the BEGIN/COMMIT is executed every time. Is there any way to assure this, I mean, to actually write the records and to not rely on the cache to do it? Because I think it is somewhere floating in the Linux cache and it's never wrote physically, and when the power is down, everything is lost.
Thank you in advance,
Leandro Fanzone