BUG #16386: drop contraint in inherited table is missing in pg_dump backup

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: szittya314(at)gmail(dot)com
Subject: BUG #16386: drop contraint in inherited table is missing in pg_dump backup
Date: 2020-04-24 10:02:47
Message-ID: 16386-a0304b15bf684ea2@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim Gündüz 2020-04-24 11:23:24 Re: BUG #16385: Postgres YUM repo broke
Previous Message Michael Paquier 2020-04-24 07:05:10 Re: [BUG] non archived WAL removed during production crash recovery