This code in our hook_nodeapi is pointless:


case 'insert' :
db_query('UPDATE {node} SET moderate = %d WHERE nid = %d', $node->moderate, $node->nid);

We come to this from node_save, which has just done a drupal_write_record(). This saves *everything* defined in node module's hook_schema, hence {node}.moderate value is already recorded.