Re: Table partitioning with sequence field in postgresql12

From: Tim Cross <theophilusx(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Table partitioning with sequence field in postgresql12
Date: 2020-06-18 06:57:42
Message-ID: 87wo44zwrd.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Srinivasa T N <seenutn(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message amul sul 2020-06-18 07:00:55 Re: Table partitioning with sequence field in postgresql12
Previous Message Srinivasa T N 2020-06-18 06:52:27 Re: Table partitioning with sequence field in postgresql12