Hi, On the latest master head, I can see a $subject bug that seems to be related commit #b0e96f311985:
Here is the table definition: create table foo(i int, j int, CONSTRAINT pk PRIMARY KEY(i) DEFERRABLE); And after restore from the dump, it shows a descriptor where column 'i' not marked NOT NULL: =# \d foo Table "public.foo" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- i | integer | | | j | integer | | | Indexes: "pk" PRIMARY KEY, btree (i) DEFERRABLE The pg_attribute entry: =# select attname, attnotnull from pg_attribute where attrelid = 'foo'::regclass and attnum > 0; attname | attnotnull ---------+------------ i | f j | f (2 rows) -- Regards, Amul Sul EDB: http://www.enterprisedb.com