BUG #8465: major dump/reload problem

The following bug has been logged on the website:

Bug reference: 8465
Logged by: Jan Mate
Email address: jan(dot)mate(at)inf-it(dot)com
PostgreSQL version: 9.3.0
Operating system: all
Description:

Hi PostgreSQL team,

today I tried to upgrade from 9.2 to 9.3 (pg_upgradecluster 9.2 main) and
the upgrade of one of my databases failed with the following error: "ERROR:
new row for relation ... violates check constraint ...".

I created an example to reproduce this bug:

http://www.inf-it.com/fixes/postgres-bugreport2/schema.sql

steps to reproduce it (tested with version 9.3):

createdb test && psql test < schema.sql
pg_dump test > dump.sql

dropdb test && createdb test && psql test < dump.sql