BTDT but mine was with a Colt Combat Commander I'd had a gunsmith install new sight on for me. Turns out he didn't know as much about silver soldering as he thought he did. He'd previously staked it and it worked loose so he was going to make sure it didn't come loose again.
Those P07/P09 front sights are usually pretty tight going in. Not the plastic factory sights like the old ones had, but any replacement sights you get for one.