The 5900 is a replacement for the 4200.
The 7900 is a replacement for the 5200.
The two cameras are identical except for the megapixels.
According to Amazon.com:
The 5900 will be shipping on April 10.
The 7900 will be shipping on May 1.
Estimated street price:
5900 - $350
7900 - $450
"Are they worth it?" -
Well, it seems we get more for our money each year.
5 megapixels for $350 doesn't sound bad.
"Which would you buy?" -
That would depend upon the need for more megapixels.
Do you have a need for 7 megapixels?
...
..
.
Have the old nikon coolpix 2500 looking to upgrade to get better and bigger picture quality. I know they both replace a previous models. Are they worth it and which one would you buy?? The 5900 or the 7900.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic