Is the author of Psalm 6:4-5 not expecting an afterlife?:
ISV Psa 6:4 Return, LORD, save my life! Deliver me, because of your gracious love. Psa 6:5 In death, there is no memory of you. Who will give you thanks where the dead are?
Is the author of Psalm 6:4-5 not expecting an afterlife?:
ISV Psa 6:4 Return, LORD, save my life! Deliver me, because of your gracious love. Psa 6:5 In death, there is no memory of you. Who will give you thanks where the dead are?
The Psalm does not have to be interpreted in terms of an afterlife.
The JPS commentary for this passage states:
Biblical Israel knew no afterlife with reward and punishment - everyone, irrespective of behavior or social status, descended to "She'ol," the dark underworld, and lived a quasi-life there. Among the dead may also be translated "in the place of death," paralleling "She'ol." (JPS Study Bible p. 1289)
The Psalm is then translated based on this tradition:
My whole being is stricken with terror, while You, LORD - O, how long! O LORD, turn! Rescue me! Deliver me as befits Your faithfulness. For there is no praise of You among the dead; in Sheol, 1 who can acclaim you? (Psalm 6:4-6 JPS)
However, as noted in the question, translations vary widely and a different translation can lead to a meaning in which the Psalmist is not speaking about life after death. The NET translation reads:
For no one remembers you in the realm of death, In Sheol who gives you thanks? (Psalm 6:5)
This translation recognizes יֽוֹדֶה־ is better rendered "give thanks" (rather than "give praise"). In this case the Psalmist can be understood as adding a rhetorical question to their prayer. That is, the Psalmist does not believe anyone gives thanks for their death or in the place of the dead.
Also the tradition of She'ol does not exclude belief in the resurrection. The New Testament describes that some of the Jewish people included a belief in believed in resurrection with a belief in She'ol:
The same day Sadducees (who say there is no resurrection) came to him and asked him (Matthew 22:23 NET)
One of the oldest books is Job and states:
For I know that my redeemer liveth, and that he shall stand at the latter day upon the earth: And though after my skin worms destroy this body, yet in my flesh shall I see God: Whom I shall see for myself, and mine eyes shall behold, and not another; though my reins be consumed within me. (Job 19:25-27 KJV)
Job is convinced that after he dies and his body decays, in his flesh he will see God with his own eyes. Job believes he will be resurrected, have a body, and see God. Yet Job does not say what he believes about She'ol or what will happen after death and before he sees God.
The tradition of She'ol is not incompatible with resurrection.
The Psalm is silent about resurrection and Job is silent about She'ol. There is no requirement to add what is not stated to either passage. So it is likely not correct to presume anything about what the Psalmist believes about resurrection.
The New Testament confirms the belief of resurrection is correct. Then the best interpretation of the Psalmist's statement is:
"Who is going to give thanks to the LORD in the place of the dead?"
In other words the Psalmist does not envision giving thanks to the LORD for their death. But they know the LORD has heard prayer (v 8) and received (v 9) their prayer. They anticipate a time when they can give both thanks and praise to the LORD for deliverance from their current circumstances which could have caused their death.
1. Or "in the place of She'ol"
This is in line with those of us who believe in what most of Christianity calls death sleep.
The dead know nothing...
For the living know that they will die; But the dead know nothing, And they have no more reward, For the memory of them is forgotten.
Ecclesiastes 9:5
The dead do not praise...
For Sheol cannot thank You, Death cannot praise You; Those who go down to the pit cannot hope for Your truth.
Isaiah 38:18
Once again...
The dead do not praise the Lord, Nor any who go down into silence.
Psalm 115:17
This is because dead is like a sleep...
Now a certain man was sick, Lazarus of Bethany, the town of Mary and her sister Martha. 2 It was that Mary who anointed the Lord with fragrant oil and wiped His feet with her hair, whose brother Lazarus was sick. 3 Therefore the sisters sent to Him, saying, “Lord, behold, he whom You love is sick.”
4 When Jesus heard that, He said, “This sickness is not unto death, but for the glory of God, that the Son of God may be glorified through it.”
5 Now Jesus loved Martha and her sister and Lazarus. 6 So, when He heard that he was sick, He stayed two more days in the place where He was. 7 Then after this He said to the disciples, “Let us go to Judea again.”
8 The disciples said to Him, “Rabbi, lately the Jews sought to stone You, and are You going there again?”
9 Jesus answered, “Are there not twelve hours in the day? If anyone walks in the day, he does not stumble, because he sees the light of this world. 10 But if one walks in the night, he stumbles, because the light is not in him.” 11 These things He said, and after that He said to them, “Our friend Lazarus sleeps, but I go that I may wake him up.”
12 Then His disciples said, “Lord, if he sleeps he will get well.” 13 However, Jesus spoke of his death, but they thought that He was speaking about taking rest in sleep.
14 Then Jesus said to them plainly, “Lazarus is dead. 15 And I am glad for your sakes that I was not there, that you may believe. Nevertheless let us go to him.”
16 Then Thomas, who is called the Twin, said to his fellow disciples, “Let us also go, that we may die with Him.”
John 11:1-16
And when Jesus comes again, he will wake those who sleep in Him from the slumber of death unto eternal life, this is the first resurrection. Read this carefully.
13 But I do not want you to be ignorant, brethren, concerning those who have fallen asleep, lest you sorrow as others who have no hope. 14 For if we believe that Jesus died and rose again, even so God will bring with Him those who sleep in Jesus.[b]
15 For this we say to you by the word of the Lord, that we who are alive and remain until the coming of the Lord will by no means precede those who are asleep. 16 For the Lord Himself will descend from heaven with a shout, with the voice of an archangel, and with the trumpet of God. And the dead in Christ will rise first. 17 Then we who are alive and remain shall be caught up together with them in the clouds to meet the Lord in the air. And thus we shall always be with the Lord. 18 Therefore comfort one another with these words.
1 Thessalonians 4:13-18
This is why they are not expecting an afterlife, because death is the cessation or end of life, so a life after death is only possible through resurrection according to the Bible.
This means that the soul is not immortal, which is also Biblical, but this is another question.
For additional information on what the Bible has to say on this topic:
http://www.amazingfacts.org/media-library/study-guide/e/4987/t/are-the-dead-really-dead
EDIT: So to make it clearer as to what I am saying, David, the author of this Psalm, in agreement with the rest of Scripture, believes that when you die you do not know anything or even praise God as it is like a sleep. However, in Psalm 23, another Psalm of David, you can clearly see that he does believe in an afterlife.
Surely goodness and mercy will follow me all the days of my life, and I will dwell in the house of the LORD forever
Psalm 23:6
The author of Psalm 73, also believes this:
You guide me with Your counsel, and afterward You will take me into glory. Whom have I in heaven but You? And earth has nothing I desire besides You.
Psalm 73:24,25
The only way to reconcile this is that they knew about the resurrection at the coming of the LORD, which is not a New Testament concept, but an Old Testament concept as well.
And many of those who sleep in the dust of the earth shall awake, Some to everlasting life, Some to shame and everlasting contempt. Those who are wise shall shine Like the brightness of the firmament, And those who turn many to righteousness Like the stars forever and ever.
Daniel 12:2-3