Re: [PATCH] Automatic HASH and LIST partition creation - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: [PATCH] Automatic HASH and LIST partition creation
Date
Msg-id alpine.DEB.2.22.394.2012221025000.533489@pseudo
Whole thread Raw
In response to Re: [PATCH] Automatic HASH and LIST partition creation  (Maxim Orlov <m.orlov@postgrespro.ru>)
Responses Re: [PATCH] Automatic HASH and LIST partition creation
List pgsql-hackers
> CREATE TABLE foo(a int) PARTITION BY LIST(a) CONFIGURATION (FOR VALUES IN 
> (1,2),(3,4) DEFAULT PARTITION foo_def);

I would like to disagree with this syntactic approach because it would 
very specific to each partition method. IMHO the syntax should be as 
generic as possible. I'd suggest (probably again) a keyword/value list 
which would allow to be quite adaptable without inducing any pressure on 
the parser.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW
Next
From: Fujii Masao
Date:
Subject: Re: Deadlock between backend and recovery may not be detected