Re: Table partitioning with sequence field in postgresql12

Поиск
Список
Период
Сортировка
От Tim Cross
Тема Re: Table partitioning with sequence field in postgresql12
Дата
Msg-id 87wo44zwrd.fsf@gmail.com
обсуждение исходный текст
Ответ на Table partitioning with sequence field in postgresql12  (Srinivasa T N <seenutn@gmail.com>)
Список pgsql-general
Srinivasa T N <seenutn@gmail.com> writes:

> Hi,
>    Partitioning of a table with sequence id as one of its fields is
> supported in postgresql12?
>
> Regards,
> Seenu.

A sequence is really just an 'atomic' number generator, you get the next
value, which is guaranteed to be larger than the last 'nextval' (up
until maxvalue). It is unaware of the use i.e. whether it will be used
in a insert or what table that insert is against. So I'm not sure what
your concern with a partitioned table is? Can you elaborate?

-- 
Tim Cross



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

Предыдущее
От: Srinivasa T N
Дата:
Сообщение: Re: Table partitioning with sequence field in postgresql12
Следующее
От: amul sul
Дата:
Сообщение: Re: Table partitioning with sequence field in postgresql12