Postgres Pro
Downloads
Home   >   mailing lists

Will crashed transaction be rollbacked? - Mailing list pgsql-novice

From Jialun Zhang
Subject Will crashed transaction be rollbacked?
Date
Msg-id CAMFL+JhNHbcg=ToHHGP_32HMn_nUZt8nT+++yzyskabBVzpmNQ@mail.gmail.com
Whole thread Raw
Responses Re: Will crashed transaction be rollbacked?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-novice
Tree view
Hi All,

If the system crashes while a transaction still in progress, what will happen to it in recovery? Will it be rollbacked? For example, if I insert a row and the insertion has been xlogged, then the system crashes before this transaction commits, will this insertion be cancelled in recovery?

Thanks,
Jialun Zhang

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: configuration problems with Debian and derivates
Next
From: Stephen Frost
Date:
Subject: Re: Will crashed transaction be rollbacked?