Add PostGIS adapter in update_id_sequence

The sequences are not updated when using the PostGIS adaptrer, like they are when using Postgres.