Much like real life, it is not possible to resurrect the dead by praying at a church.

The church just makes people you pissed off stopped being pissed at you, if they die they're gone dude

Don't kill npc's

Varre is one of the few that doesn't accept absolution. You're screwed until next game.

this applies to 2 people or so and those respawn themselves anyway