PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16386
PG Version10.12
OScentos 7
Opened2020-04-24 10:02:47+00
Reported byklement szabolcs
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16386
Logged by:          klement szabolcs
Email address:      (redacted)
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;

Messages

DateAuthorSubject
2020-04-24 10:02:47+00PG Bug reporting formBUG #16386: drop contraint in inherited table is missing in pg_dump backup
2020-04-24 15:13:01+00Euler TaveiraRe: BUG #16386: drop contraint in inherited table is missing in pg_dump backup
2020-04-24 15:28:39+00Alvaro HerreraRe: BUG #16386: drop contraint in inherited table is missing in pg_dump backup
2020-04-24 16:08:00+00Tom LaneRe: BUG #16386: drop contraint in inherited table is missing in pg_dump backup