On Thu, Jun 18, 2020 at 12:22 PM Srinivasa T N <seenutn@xxxxxxxxx> 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 into child tables, will there be any race condition causing two child tables getting the same sequence value for gid?
>
if "gid" is the partitioning key and assuming you are using declarative
partitioning[1], then it won't be possible to have the same "gid" value in two
child partitions.
1] https://www.postgresql.org/docs/current/ddl-partitioning.html
regards,
Amul
