After retrying the scenario, I found the problem is in the dump, and the constraint is missing in the backup file.
Sabin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin