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
I am trying to patch postgres to accept this query. A recursive query
referencing the recursive table twice. By removing some checks it accepts
the query and generates a plan.
### Query
create table base(k1,k2,k3) as (values
(1,null,null),(2,null,null),(3,1,2));
with recursive x(k1,k2,k3) as (