Fails to update legal_accepted under PostgreSQL

This line fails under PostgreSQL:

db_query("INSERT INTO {legal_accepted} (legal_id, uid, tc_id, accepted) VALUES (NULL, '%d', '%d', '%d')", $uid, $tc_id, time());

I'm surprised that it works under MySQL since legal_id is an auto_increment column and shouldn't be given a value at all.