Re: Patch for automated partitioning

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: Patch for automated partitioning
Дата
Msg-id 20091102164405.C6C3.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Patch for automated partitioning  (shrish purohit <shrishpurohit@gmail.com>)
Список pgsql-hackers
shrish purohit <shrishpurohit@gmail.com> wrote:

> Updated Kedar's patch sending on behalf of Kedar.
> There are not toomany modifications. It includes improvements for validating
> multi-column partitioned tables.

Thanks, but I'd like to keep the first patch as possible as simple.
I'll refer your work in the *next* step, especially partition
triggers and ALTER commands.

I glanced over your patch and find some codes that have room for improvement:
 * Need to avoid RANGE and PARTITION to be reserved keywords. * Non SQL-based operations are preferred if possible, so
needto   reconsider pg_parse_query(). * Adding NOTICE message to completionTag is a very bad idea.   we don't need such
featurebecause users can create trigger   on the overflow partition to send those messages.
 

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: operator exclusion constraints
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)