make sure zip is required for canada, also use CURRVAL() function instead of pg_oid_s...