BUG #16386: drop contraint in inherited table is missing in pg_dump backup - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16386: drop contraint in inherited table is missing in pg_dump backup
Date
Msg-id 16386-a0304b15bf684ea2@postgresql.org
Whole thread Raw
Responses Re: BUG #16386: drop contraint in inherited table is missing inpg_dump backup
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16386
Logged by:          klement szabolcs
Email address:      szittya314@gmail.com
PostgreSQL version: 10.12
Operating system:   centos 7
Description:

create table b (aaa int primary key,bb date );
create table A (id int primary key) inherits (B);
alter table a alter column aaa drop not null;

after i made pg_dump and pg_restore the not null contraint isexist on table
a;


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUG] non archived WAL removed during production crash recovery
Next
From: Devrim Gündüz
Date:
Subject: Re: BUG #16385: Postgres YUM repo broke