The Rose and the Jackal (1990)

Detective Allan Pinkerton, working for the Union, becomes obsessed with Southern socialite Rose O'Neal Greenhow, a spy for the Confederacy.