No, I mean that that's the point of fridging--the female character is killed so the male hero can have an "Oh god" moment(see: Kyle Rayner) and be infused with the will to kick asses and take names. This is why it's sexist.
So bringing women back from the dead in this situation is pointless by mainstream comic logic.
Except, I seem to recall John Stewart recently had a Blue Lantern-induced vision that he'd see Katma Tui again. I think we now know how.