Re: [PATCH] Automatic HASH and LIST partition creation
От | Pavel Borisov |
---|---|
Тема | Re: [PATCH] Automatic HASH and LIST partition creation |
Дата | |
Msg-id | CALT9ZEG9oKz9-dv9YYZaeeXNpZp0+teLFSz7QST28AcmERVpiw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [PATCH] Automatic HASH and LIST partition creation (Nitin Jadhav <nitinjadhavpostgres@gmail.com>) |
Ответы |
Re: [PATCH] Automatic HASH and LIST partition creation
|
Список | pgsql-hackers |
I have reviewed the v4 patch. The patch does not get applied on the latest source. Kindly rebase.However I have found few comments.1.> +-- must fail because of wrong configuration> +CREATE TABLE tbl_hash_fail (i int) PARTITION BY HASH (i)> +CONFIGURATION (values in (1, 2), (3, 4) default partition tbl_default);Here some of the keywords are mentioned in UPPER CASE (Ex: CREATE TABLE, CONFIGURATION, etc) and some are mentioned in lower case (Ex: values in, default partition, etc). Kindly make it common. I feel making it to UPPER CASE is better. Please take care of this in all the cases.2. It is better to separate the failure cases and success cases in /src/test/regress/sql/create_table.sql for better readability. All the failure cases can be listed first and then the success cases.3.> + char *part_relname;> +> + /*> + * Generate partition name in the format:> + * $relname_$partnum> + * All checks of name validity will be made afterwards in DefineRelation()> + */> + part_relname = psprintf("%s_%d", cxt->relation->relname, i);The assignment can be done directly while declaring the variable.
Thank you for your review!
I've rebased the patch and made the changes mentioned.
PFA v5.
Вложения
В списке pgsql-hackers по дате отправления: