[HACKERS] Suporting multiple recursive table reads

2015-10-21 Thread Wesley Massuda
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 (

[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