Re: Declarative partitioning grammar

Поиск
Список
Период
Сортировка
От Markus Schiltknecht
Тема Re: Declarative partitioning grammar
Дата
Msg-id 478CD585.1020009@bluegap.ch
обсуждение исходный текст
Ответ на Re: Declarative partitioning grammar  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Declarative partitioning grammar  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Declarative partitioning grammar  ("Zeugswetter Andreas ADI SD" <Andreas.Zeugswetter@s-itsolutions.at>)
Список pgsql-hackers
Hi,

Tom Lane wrote:
> I don't agree with that at all.  I can imagine plenty of situations
> where a tuple falling outside the range of available partitions *should*
> be treated as an error.  For instance, consider timestamped observations
> --- data in the future is certainly bogus, and data further back than
> you want to deal with must be an entry error as well.

Isn't it better to have these constraints as table constraints, instead 
of burying them in the partitioning definition? Mixing those two 
concepts seems very wired to me.

Or am I missing any benefit of mixing them?

Regards

Markus


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SSL over Unix-domain sockets
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: SSL over Unix-domain sockets