fix assign id for greenplum