Ghost Town.
This is a new film due to be released on the 24th of October in the UK and apparently you darned yanks already have it. Anyway, it's directed by David Koepp and stars Ricky Gervais and Greg Kinnear.
Synopsis time:
In the romantic comedy "Ghost Town," Bertram Pincus (Ricky Gervais), is a man whose people skills leave much to be desired. When Pincus dies unexpectedly, but is miraculously revived after seven minutes, he wakes up to discover that he now has the annoying ability to see ghosts. Even worse, they all want something from him, particularly Frank Herlihy (Greg Kinnear) who pesters him into breaking up the impending marriage of his widow Gwen (Téa Leoni). That puts Pincus squarely in the middle of a triangle with spirited result.
http://www.imdb.com/title/tt0995039/plotsummary
Now, I'm going to the trouble of providing a trailer for you, so watch it, you dogs.