Re: BUG #19393: pg_upgrade fails with duplicate key violation when CHECK constraint named *_not_null exists - Mailing list pgsql-hackers

From Hüseyin Demir
Subject Re: BUG #19393: pg_upgrade fails with duplicate key violation when CHECK constraint named *_not_null exists
Date
Msg-id 177157035357.626.5599596504298221780.pgcf@coridan.postgresql.org
Whole thread Raw
List pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, failed
Spec compliant:           tested, failed
Documentation:            tested, failed

Hi,

I reviewed and tested v2 of this patch.

Builds with zero errors and zero warnings and all tests passed.

Verified the fix against Bug #19393. The original crash (unique key violation on
pg_constraint_conrelid_contypid_conname_index)no longer occurs.
 
Also tested edge cases: cascading collisions (name, name1, name2 all taken), multiple NOT NULL columns with mixed
collisions,and the normal no-collision case. All work
 
correctly. No doc changes needed.

The new status of this patch is: Ready for Committer

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [PATCH] Support automatic sequence replication
Next
From: Amit Kapila
Date:
Subject: Re: Patch for migration of the pg_commit_ts directory