pgsql: Catalog not-null constraints

2023-08-25 Thread Alvaro Herrera
Catalog not-null constraints We now create contype='n' pg_constraint rows for not-null constraints. We propagate these constraints to other tables during operations such as adding inheritance relationships, creating and attaching partitions and creating tables LIKE other tables. We also spawn no

Re: pgsql: Catalog NOT NULL constraints

2023-04-11 Thread David Rowley
On Sat, 8 Apr 2023 at 06:09, Alvaro Herrera wrote: > Catalog NOT NULL constraints I think transformTableLikeClause() contains a small issue because process_notnull_constraints is not set to false by default. Per valgrind, it looks like the variable can be uninitialised by the time it's reference

pgsql: Catalog NOT NULL constraints

2023-04-07 Thread Alvaro Herrera
Catalog NOT NULL constraints We now create pg_constaint rows for NOT NULL constraints with contype='n'. We propagate these constraints during operations such as adding inheritance relationships, creating and attaching partitions, creating tables LIKE other tables. We mostly follow the well-known