Re: [HACKERS] Proposal : composite type not null constraints

2016-12-15 Thread Tom Lane
Wesley Massuda writes: > I would like to propose extending composite types with constraints. I'm not convinced we should go there, *particularly* not for not-null constraints. Data-type-related not-null constraints are broken by design, because they are fundamentally inconsistent with outer join

[HACKERS] Proposal : composite type not null constraints

2016-12-15 Thread Wesley Massuda
I would like to propose extending composite types with constraints. Currently there is a preliminar patch for not null constraints. === Changes : -Use the parser from create table to get the constraints 'OptTableElementList' instead of 'OptTableFuncElementList'. - Add a new transformation tran