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
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"
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
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
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
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,
Partitioning of a table with sequence id as one of its fields is
supported in postgresql12?
Regards,
Seenu.
