Hi,
Partitioning of a table with sequence id as one of its fields is
supported in postgresql12?
Regards,
Seenu.
On Thu, Jun 18, 2020 at 12:00 PM Srinivasa T N wrote:
>
> Hi,
>Partitioning of a table with sequence id as one of its fields is supported
> in postgresql12?
>
Could you please elaborate on your case a bit more?
Regards,
Amul
Hi,
I have a parent table with one of the field as ""gid" int4 DEFAULT
nextval('"ami_smart_new".aoi_boundary_gid_seq'::regclass)".
I create child tables which inherit parent and use hash partition. When
I directly insert into child tables, will there be any race condition
causing two child
Srinivasa T N 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
unti
On Thu, Jun 18, 2020 at 12:22 PM Srinivasa T N wrote:
>
> Hi,
>I have a parent table with one of the field as ""gid" int4 DEFAULT
> nextval('"ami_smart_new".aoi_boundary_gid_seq'::regclass)".
>
>I create child tables which inherit parent and use hash partition. When I
> directly insert
I am using declarative partitioning on some other field of the same table
in which gid also exists.
Regards,
Seenu.
On Thu, Jun 18, 2020 at 12:31 PM amul sul wrote:
> On Thu, Jun 18, 2020 at 12:22 PM Srinivasa T N wrote:
> >
> > Hi,
> >I have a parent table with one of the field as ""gid"
Srinivasa T N writes:
> Hi,
>I have a parent table with one of the field as ""gid" int4 DEFAULT
> nextval('"ami_smart_new".aoi_boundary_gid_seq'::regclass)".
>
>I create child tables which inherit parent and use hash partition. When
> I directly insert into child tables, will there be