Use drupal_write_record not INSERT/UPDATE.

Most of the INSERT queries use MySQL-only syntax that is not ANSI INSERT syntax and thus bails in PostgreSQL and likely any other future db that Drupal makes it on. The attached patch addresses these. Also there are a couple UPDATE queries where one of the columns being updated is variable and so can be an integer or varchar but the placeholder used in the queries is '%s' which is only for strings. Again MySQL glosses over this (probably would fail in ANSI strict mode) but PostgreSQL rightly complains. The patch tests the $field_name for whether it's the varchar column or an int and uses the db_placeholders() function to set the right placeholder.

See related issue #340765: Install issue inserting data into tables