Re: Table partitioning with sequence field in postgresql12 - Mailing list pgsql-general

From Tim Cross
Subject Re: Table partitioning with sequence field in postgresql12
Date
Msg-id 87wo44zwrd.fsf@gmail.com
Whole thread Raw
In response to Table partitioning with sequence field in postgresql12  (Srinivasa T N <seenutn@gmail.com>)
List 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 by date:

Previous
From: Srinivasa T N
Date:
Subject: Re: Table partitioning with sequence field in postgresql12
Next
From: amul sul
Date:
Subject: Re: Table partitioning with sequence field in postgresql12