Contradiction with Genesis 7:11
Psalms 78:23 mentions God commanding the clouds above and opening the doors of heaven, indicating rain as a blessing, while Genesis 7:11 refers to the opening of the heavens as part of the judgment of the flood.
Genesis 7:11: In the six hundredth year of Noah's life, in the second month, the seventeenth day of the month, the same day were all the fountains of the great deep broken up, and the windows of heaven were opened. [windows: or, floodgates]
Contradiction with Malachi 3:10
Psalms 78:23 implies God's control over the heavens for provision, whereas Malachi 3:10 challenges people to test God to open the windows of heaven for blessings, suggesting human action prompts the opening.
Malachi 3:10: Bring ye all the tithes into the storehouse, that there may be meat in mine house, and prove me now herewith, saith the LORD of hosts, if I will not open you the windows of heaven, and pour you out a blessing, that [there shall] not [be room] enough [to receive it]. [pour...: Heb. empty out]
Contradiction with Isaiah 24:18
Psalms 78:23 associates the opening of heaven with a divine act of sustenance, while Isaiah 24:18 speaks of the windows of heaven opening as part of judgment and destruction.
Isaiah 24:18: And it shall come to pass, [that] he who fleeth from the noise of the fear shall fall into the pit; and he that cometh up out of the midst of the pit shall be taken in the snare: for the windows from on high are open, and the foundations of the earth do shake.