The President of the United States swears an oath to defend the Constitution. In my opinion this trumps his duty to execute the laws of the land. This issue recently came to the forefront when Obama gave orders to the Department of Justice not to defend the Defense of Marriage Act.
Here's an article that does a good job arguing the position I hold.