MIME-Version: 1.0
From: Shaheed Haque <shaheedhaque@gmail.com>
Date: Sat, 22 Jun 2024 18:01:44 +0100
Message-ID: <CAHAc2jeB+Mzm1Kz-4Uq2CN=EGxdJO17tE0Aqm20BQUV9rGr1QQ@mail.gmail.com>
Subject: pg_dump restores as expected on some machines and reports duplicate
 keys on others
To: pgsql-general list <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005d45f8061b7d817d"
Archived-At: <https://www.postgresql.org/message-id/CAHAc2jeB%2BMzm1Kz-4Uq2CN%3DEGxdJO17tE0Aqm20BQUV9rGr1QQ%40mail.gmail.com>
Precedence: bulk

--0000000000005d45f8061b7d817d
Content-Type: text/plain; charset="UTF-8"

Hi,

I am using Postgres 14 on AWS RDS and am seeing the output of pg_dump be
restored as expected by pg_restore on some database instances, and fail
with reports of duplicate keys on other database instances:

   - My deployments are always a pair, one "logic VM" for Django etc and
   one "RDS instance". The psql client runs on the logic VM. The Postgres
   version is the same in all cases; psql reports:


   - psql (14.12 (Ubuntu 14.12-0ubuntu0.22.04.1), server 14.9)


   - The pg_restore is done using the same script in both cases.
   - In the failing cases, there are always the same 26 errors (listed in
   detail below), but in summary, 3 distinct "child" tables complain of a
   duplicate id=1, id=2 and id=3 respectively.
   - These "child" tables are FK-related via some intermediate table to a
   top level table. They form a polymorphic set. There are other similar child
   tables which do not appear to be affected:
      - polymorphicmodel
         - companybankdetail
            - companybankdetailde
            - companybankdetailgb  <<< 1 duplicate, id=2
            - companybankdetailus
            - companypostaldetail
            - companypostaldetailde
            - companypostaldetailgb  <<< 1 duplicate, id=1
            - companypostaldetailus
         - companytaxdetail
            - companytaxdetailde
            - companytaxdetailgb  <<< 1 duplicate, id=3
            - companytaxdetailus
         - ...
         - several other hierarchies, all error free
         - ...
      - I've looked at the dumped NNNN.dat files but they contain no
   duplicates.
   - The one difference I can think of between deployment pairs which work
   ok, and those which fail is that the logic VM (i.e. where the psql client
   script runs) is the use of a standard AWS ubuntu image for the OK case,
   versus a custom AWS image for the failing case.
      - The custom image is a saved snapshot of one created using the
      standard image.

Why should the use of one type of VM image versus another cause pg_restore
to hallucinate the duplicate records?

Encls: 26 errors as mentioned...

========
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 5635; 1262 53894 DATABASE foo postgres
pg_restore: error: could not execute query: ERROR:  database "foo" already
exists
Command was: CREATE DATABASE foo WITH TEMPLATE = template0 ENCODING =
'UTF8' LOCALE = 'en_US.UTF-8';


pg_restore: from TOC entry 4808; 2606 80439 CONSTRAINT
paiyroll_companybankdetail paiyroll_companybankdetail_pkey dbcoreuser
pg_restore: error: could not execute query: ERROR:  could not create unique
index "paiyroll_companybankdetail_pkey"
DETAIL:  Key (polymorphicmodel_ptr_id)=(2) is duplicated.
Command was: ALTER TABLE ONLY public.paiyroll_companybankdetail
   ADD CONSTRAINT paiyroll_companybankdetail_pkey PRIMARY KEY
(polymorphicmodel_ptr_id);


pg_restore: from TOC entry 4812; 2606 80443 CONSTRAINT
paiyroll_companybankdetailgb paiyroll_companybankdetailgb_pkey dbcoreuser
pg_restore: error: could not execute query: ERROR:  could not create unique
index "paiyroll_companybankdetailgb_pkey"
DETAIL:  Key (companybankdetail_ptr_id)=(2) is duplicated.
Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailgb
   ADD CONSTRAINT paiyroll_companybankdetailgb_pkey PRIMARY KEY
(companybankdetail_ptr_id);


pg_restore: from TOC entry 4817; 2606 80447 CONSTRAINT
paiyroll_companypostaldetail paiyroll_companypostaldetail_pkey dbcoreuser
pg_restore: error: could not execute query: ERROR:  could not create unique
index "paiyroll_companypostaldetail_pkey"
DETAIL:  Key (polymorphicmodel_ptr_id)=(1) is duplicated.
Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetail
   ADD CONSTRAINT paiyroll_companypostaldetail_pkey PRIMARY KEY
(polymorphicmodel_ptr_id);


pg_restore: from TOC entry 4821; 2606 80451 CONSTRAINT
paiyroll_companypostaldetailgb paiyroll_companypostaldetailgb_pkey
dbcoreuser
pg_restore: error: could not execute query: ERROR:  could not create unique
index "paiyroll_companypostaldetailgb_pkey"
DETAIL:  Key (companypostaldetail_ptr_id)=(1) is duplicated.
Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailgb
   ADD CONSTRAINT paiyroll_companypostaldetailgb_pkey PRIMARY KEY
(companypostaldetail_ptr_id);


pg_restore: from TOC entry 4826; 2606 80455 CONSTRAINT
paiyroll_companytaxdetail paiyroll_companytaxdetail_pkey dbcoreuser
pg_restore: error: could not execute query: ERROR:  could not create unique
index "paiyroll_companytaxdetail_pkey"
DETAIL:  Key (polymorphicmodel_ptr_id)=(3) is duplicated.
Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetail
   ADD CONSTRAINT paiyroll_companytaxdetail_pkey PRIMARY KEY
(polymorphicmodel_ptr_id);


pg_restore: from TOC entry 4830; 2606 80459 CONSTRAINT
paiyroll_companytaxdetailgb paiyroll_companytaxdetailgb_pkey dbcoreuser
pg_restore: error: could not execute query: ERROR:  could not create unique
index "paiyroll_companytaxdetailgb_pkey"
DETAIL:  Key (companytaxdetail_ptr_id)=(3) is duplicated.
Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailgb
   ADD CONSTRAINT paiyroll_companytaxdetailgb_pkey PRIMARY KEY
(companytaxdetail_ptr_id);


pg_restore: from TOC entry 5018; 2606 80614 CONSTRAINT
paiyroll_polymorphicmodel paiyroll_polymorphicmodel_pkey dbcoreuser
pg_restore: error: could not execute query: ERROR:  could not create unique
index "paiyroll_polymorphicmodel_pkey"
DETAIL:  Key (id)=(3) is duplicated.
Command was: ALTER TABLE ONLY public.paiyroll_polymorphicmodel
   ADD CONSTRAINT paiyroll_polymorphicmodel_pkey PRIMARY KEY (id);


pg_restore: from TOC entry 5207; 2606 81004 FK CONSTRAINT
paiyroll_companybankdetailde
paiyroll_companybank_companybankdetail_pt_282859e0_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companybankdetail"
Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailde
   ADD CONSTRAINT
paiyroll_companybank_companybankdetail_pt_282859e0_fk_paiyroll_ FOREIGN KEY
(companybankdetail_ptr_id) REFERENCES
public.paiyroll_companybankdetail(polymorphicmodel_ptr_id) DEF
ERRABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5209; 2606 81009 FK CONSTRAINT
paiyroll_companybankdetailus
paiyroll_companybank_companybankdetail_pt_555d62e4_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companybankdetail"
Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailus
   ADD CONSTRAINT
paiyroll_companybank_companybankdetail_pt_555d62e4_fk_paiyroll_ FOREIGN KEY
(companybankdetail_ptr_id) REFERENCES
public.paiyroll_companybankdetail(polymorphicmodel_ptr_id) DEF
ERRABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5208; 2606 81014 FK CONSTRAINT
paiyroll_companybankdetailgb
paiyroll_companybank_companybankdetail_pt_5cf33abb_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companybankdetail"
Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailgb
   ADD CONSTRAINT
paiyroll_companybank_companybankdetail_pt_5cf33abb_fk_paiyroll_ FOREIGN KEY
(companybankdetail_ptr_id) REFERENCES
public.paiyroll_companybankdetail(polymorphicmodel_ptr_id) DEF
ERRABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5206; 2606 81019 FK CONSTRAINT
paiyroll_companybankdetail
paiyroll_companybank_polymorphicmodel_ptr_d05e0f06_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_companybankdetail
   ADD CONSTRAINT
paiyroll_companybank_polymorphicmodel_ptr_d05e0f06_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFER
RED;


pg_restore: from TOC entry 5213; 2606 81029 FK CONSTRAINT
paiyroll_companypostaldetailgb
paiyroll_companypost_companypostaldetail__86015d44_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companypostaldetail"
Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailgb
   ADD CONSTRAINT
paiyroll_companypost_companypostaldetail__86015d44_fk_paiyroll_ FOREIGN KEY
(companypostaldetail_ptr_id) REFERENCES
public.paiyroll_companypostaldetail(polymorphicmodel_ptr_id)
DEFERRABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5214; 2606 81034 FK CONSTRAINT
paiyroll_companypostaldetailus
paiyroll_companypost_companypostaldetail__963c29cd_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companypostaldetail"
Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailus
   ADD CONSTRAINT
paiyroll_companypost_companypostaldetail__963c29cd_fk_paiyroll_ FOREIGN KEY
(companypostaldetail_ptr_id) REFERENCES
public.paiyroll_companypostaldetail(polymorphicmodel_ptr_id)
DEFERRABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5212; 2606 81039 FK CONSTRAINT
paiyroll_companypostaldetailde
paiyroll_companypost_companypostaldetail__f51f0ce0_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companypostaldetail"
Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailde
   ADD CONSTRAINT
paiyroll_companypost_companypostaldetail__f51f0ce0_fk_paiyroll_ FOREIGN KEY
(companypostaldetail_ptr_id) REFERENCES
public.paiyroll_companypostaldetail(polymorphicmodel_ptr_id)
DEFERRABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5211; 2606 81044 FK CONSTRAINT
paiyroll_companypostaldetail
paiyroll_companypost_polymorphicmodel_ptr_d9fc1568_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetail
   ADD CONSTRAINT
paiyroll_companypost_polymorphicmodel_ptr_d9fc1568_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFER
RED;


pg_restore: from TOC entry 5217; 2606 81054 FK CONSTRAINT
paiyroll_companytaxdetailde
paiyroll_companytaxd_companytaxdetail_ptr_6509fa4d_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companytaxdetail"
Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailde
   ADD CONSTRAINT
paiyroll_companytaxd_companytaxdetail_ptr_6509fa4d_fk_paiyroll_ FOREIGN KEY
(companytaxdetail_ptr_id) REFERENCES
public.paiyroll_companytaxdetail(polymorphicmodel_ptr_id) DEFER
RABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5219; 2606 81059 FK CONSTRAINT
paiyroll_companytaxdetailus
paiyroll_companytaxd_companytaxdetail_ptr_b8b74e53_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companytaxdetail"
Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailus
   ADD CONSTRAINT
paiyroll_companytaxd_companytaxdetail_ptr_b8b74e53_fk_paiyroll_ FOREIGN KEY
(companytaxdetail_ptr_id) REFERENCES
public.paiyroll_companytaxdetail(polymorphicmodel_ptr_id) DEFER
RABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5218; 2606 81064 FK CONSTRAINT
paiyroll_companytaxdetailgb
paiyroll_companytaxd_companytaxdetail_ptr_d9437c9a_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_companytaxdetail"
Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailgb
   ADD CONSTRAINT
paiyroll_companytaxd_companytaxdetail_ptr_d9437c9a_fk_paiyroll_ FOREIGN KEY
(companytaxdetail_ptr_id) REFERENCES
public.paiyroll_companytaxdetail(polymorphicmodel_ptr_id) DEFER
RABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5216; 2606 81069 FK CONSTRAINT
paiyroll_companytaxdetail
paiyroll_companytaxd_polymorphicmodel_ptr_41f5cde7_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetail
   ADD CONSTRAINT
paiyroll_companytaxd_polymorphicmodel_ptr_41f5cde7_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFER
RED;


pg_restore: from TOC entry 5221; 2606 81079 FK CONSTRAINT paiyroll_debbie
paiyroll_debbie_polymorphicmodel_ptr_8b0fe25a_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_debbie
   ADD CONSTRAINT
paiyroll_debbie_polymorphicmodel_ptr_8b0fe25a_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFERRED;


pg_restore: from TOC entry 5234; 2606 81159 FK CONSTRAINT
paiyroll_employeebankdetail
paiyroll_employeeban_polymorphicmodel_ptr_6b4ae3ff_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_employeebankdetail
   ADD CONSTRAINT
paiyroll_employeeban_polymorphicmodel_ptr_6b4ae3ff_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFER
RED;


pg_restore: from TOC entry 5239; 2606 81184 FK CONSTRAINT
paiyroll_employeepostaldetail
paiyroll_employeepos_polymorphicmodel_ptr_4b75f2aa_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_employeepostaldetail
   ADD CONSTRAINT
paiyroll_employeepos_polymorphicmodel_ptr_4b75f2aa_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFER
RED;


pg_restore: from TOC entry 5249; 2606 81229 FK CONSTRAINT
paiyroll_employeetaxeedetail
paiyroll_employeetax_polymorphicmodel_ptr_2554ee34_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_employeetaxeedetail
   ADD CONSTRAINT
paiyroll_employeetax_polymorphicmodel_ptr_2554ee34_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFER
RED;


pg_restore: from TOC entry 5244; 2606 81234 FK CONSTRAINT
paiyroll_employeetaxdetail
paiyroll_employeetax_polymorphicmodel_ptr_8c064f71_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_employeetaxdetail
   ADD CONSTRAINT
paiyroll_employeetax_polymorphicmodel_ptr_8c064f71_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFER
RED;


pg_restore: from TOC entry 5258; 2606 81264 FK CONSTRAINT paiyroll_missing
paiyroll_missing_polymorphicmodel_ptr_a1958c79_fk_paiyroll_ dbcoreuser
pg_restore: error: could not execute query: ERROR:  there is no unique
constraint matching given keys for referenced table
"paiyroll_polymorphicmodel"
Command was: ALTER TABLE ONLY public.paiyroll_missing
   ADD CONSTRAINT
paiyroll_missing_polymorphicmodel_ptr_a1958c79_fk_paiyroll_ FOREIGN KEY
(polymorphicmodel_ptr_id) REFERENCES public.paiyroll_polymorphicmodel(id)
DEFERRABLE INITIALLY DEFERRED;


pg_restore: warning: errors ignored on restore: 26
========

--0000000000005d45f8061b7d817d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>I am using Postgres 14 o=
n AWS RDS and am seeing the output of pg_dump be restored as expected by pg=
_restore on some database instances, and fail with reports of duplicate key=
s on other database instances:</div><div><ul><li>My deployments are always =
a pair, one &quot;logic VM&quot; for Django etc and one &quot;RDS instance&=
quot;. The psql client runs on the logic VM. The Postgres version is the sa=
me in all cases; psql reports:</li></ul><ul><ul><li><span style=3D"font-fam=
ily:monospace"><span style=3D"color:rgb(0,0,0);background-color:rgb(255,255=
,255)">psql (14.12 (Ubuntu 14.12-0ubuntu0.22.04.1), server 14.9)</span></sp=
an></li></ul></ul></div><div><span style=3D"font-family:monospace"><span st=
yle=3D"color:rgb(0,0,0);background-color:rgb(255,255,255)"></span></span></=
div><div><ul><li>The pg_restore is done using the same script in both cases=
.</li><li>In the failing cases, there are always the same 26 errors (listed=
 in detail below), but in summary, 3 distinct &quot;child&quot; tables comp=
lain of a duplicate id=3D1, id=3D2 and id=3D3 respectively.=C2=A0</li><li>T=
hese &quot;child&quot; tables are FK-related via some intermediate table to=
 a top level table. They form a polymorphic set. There are other similar ch=
ild tables which do not appear to be affected:</li><ul><li>polymorphicmodel=
</li><ul><li>companybankdetail</li><ul><li>companybankdetailde</li><li>comp=
anybankdetailgb=C2=A0 &lt;&lt;&lt; 1 duplicate, id=3D2<br></li><li>companyb=
ankdetailus<br></li></ul><li>companypostaldetail</li><ul><li>companypostald=
etailde</li><li>companypostaldetailgb=C2=A0 &lt;&lt;&lt; 1 duplicate, id=3D=
1<br></li><li>companypostaldetailus</li></ul><li>companytaxdetail</li><ul><=
li>companytaxdetailde</li><li>companytaxdetailgb=C2=A0 &lt;&lt;&lt; 1 dupli=
cate, id=3D3<br></li><li>companytaxdetailus</li></ul><li>...</li><li>severa=
l other hierarchies, all error free</li><li>...</li></ul></ul><li>I&#39;ve =
looked at the dumped NNNN.dat files but they contain no duplicates.</li><li=
>The one difference I can think of between deployment pairs which work ok, =
and those which fail is that the logic VM (i.e. where the psql client scrip=
t runs) is the use of a standard AWS ubuntu image for the OK case, versus a=
 custom AWS image for the failing case.</li><ul><li>The custom image is a s=
aved snapshot of one created using the standard image.<br></li></ul></ul><d=
iv>Why should the use of one type of VM image versus another cause pg_resto=
re to hallucinate the duplicate records?<br></div><div><br></div><div>Encls=
: 26 errors as mentioned...</div><div><br></div><div>=3D=3D=3D=3D=3D=3D=3D=
=3D</div><div><span style=3D"font-family:monospace"><span style=3D"color:rg=
b(0,0,0);background-color:rgb(255,255,255)">pg_restore: while PROCESSING TO=
C:
</span><br>pg_restore: from TOC entry 5635; 1262 53894 DATABASE foo postgre=
s
<br>pg_restore: error: could not execute query: ERROR: =C2=A0database &quot=
;foo&quot; already exists
<br>Command was: CREATE DATABASE foo WITH TEMPLATE =3D template0 ENCODING =
=3D &#39;UTF8&#39; LOCALE =3D &#39;en_US.UTF-8&#39;;
<br>
<br>
<br>pg_restore: from TOC entry 4808; 2606 80439 CONSTRAINT paiyroll_company=
bankdetail paiyroll_companybankdetail_pkey dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0could not crea=
te unique index &quot;paiyroll_companybankdetail_pkey&quot;
<br>DETAIL: =C2=A0Key (polymorphicmodel_ptr_id)=3D(2) is duplicated.
<br>Command was: ALTER TABLE ONLY public.paiyroll_companybankdetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companybankdetail_pkey PRIMA=
RY KEY (polymorphicmodel_ptr_id);
<br>
<br>
<br>pg_restore: from TOC entry 4812; 2606 80443 CONSTRAINT paiyroll_company=
bankdetailgb paiyroll_companybankdetailgb_pkey dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0could not crea=
te unique index &quot;paiyroll_companybankdetailgb_pkey&quot;
<br>DETAIL: =C2=A0Key (companybankdetail_ptr_id)=3D(2) is duplicated.
<br>Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailgb
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companybankdetailgb_pkey PRI=
MARY KEY (companybankdetail_ptr_id);
<br>
<br>
<br>pg_restore: from TOC entry 4817; 2606 80447 CONSTRAINT paiyroll_company=
postaldetail paiyroll_companypostaldetail_pkey dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0could not crea=
te unique index &quot;paiyroll_companypostaldetail_pkey&quot;
<br>DETAIL: =C2=A0Key (polymorphicmodel_ptr_id)=3D(1) is duplicated.
<br>Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companypostaldetail_pkey PRI=
MARY KEY (polymorphicmodel_ptr_id);
<br>
<br>
<br>pg_restore: from TOC entry 4821; 2606 80451 CONSTRAINT paiyroll_company=
postaldetailgb paiyroll_companypostaldetailgb_pkey dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0could not crea=
te unique index &quot;paiyroll_companypostaldetailgb_pkey&quot;
<br>DETAIL: =C2=A0Key (companypostaldetail_ptr_id)=3D(1) is duplicated.
<br>Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailgb
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companypostaldetailgb_pkey P=
RIMARY KEY (companypostaldetail_ptr_id);
<br>
<br>
<br>pg_restore: from TOC entry 4826; 2606 80455 CONSTRAINT paiyroll_company=
taxdetail paiyroll_companytaxdetail_pkey dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0could not crea=
te unique index &quot;paiyroll_companytaxdetail_pkey&quot;
<br>DETAIL: =C2=A0Key (polymorphicmodel_ptr_id)=3D(3) is duplicated.
<br>Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companytaxdetail_pkey PRIMAR=
Y KEY (polymorphicmodel_ptr_id);
<br>
<br>
<br>pg_restore: from TOC entry 4830; 2606 80459 CONSTRAINT paiyroll_company=
taxdetailgb paiyroll_companytaxdetailgb_pkey dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0could not crea=
te unique index &quot;paiyroll_companytaxdetailgb_pkey&quot;
<br>DETAIL: =C2=A0Key (companytaxdetail_ptr_id)=3D(3) is duplicated.
<br>Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailgb
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companytaxdetailgb_pkey PRIM=
ARY KEY (companytaxdetail_ptr_id);
<br>
<br>
<br>pg_restore: from TOC entry 5018; 2606 80614 CONSTRAINT paiyroll_polymor=
phicmodel paiyroll_polymorphicmodel_pkey dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0could not crea=
te unique index &quot;paiyroll_polymorphicmodel_pkey&quot;
<br>DETAIL: =C2=A0Key (id)=3D(3) is duplicated.
<br>Command was: ALTER TABLE ONLY public.paiyroll_polymorphicmodel
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_polymorphicmodel_pkey PRIMAR=
Y KEY (id);
<br>
<br>
<br>pg_restore: from TOC entry 5207; 2606 81004 FK CONSTRAINT paiyroll_comp=
anybankdetailde paiyroll_companybank_companybankdetail_pt_282859e0_fk_paiyr=
oll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panybankdetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailde
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companybank_companybankdetai=
l_pt_282859e0_fk_paiyroll_ FOREIGN KEY (companybankdetail_ptr_id) REFERENCE=
S public.paiyroll_companybankdetail(polymorphicmodel_ptr_id) DEF<br>ERRABLE=
 INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5209; 2606 81009 FK CONSTRAINT paiyroll_comp=
anybankdetailus paiyroll_companybank_companybankdetail_pt_555d62e4_fk_paiyr=
oll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panybankdetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailus
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companybank_companybankdetai=
l_pt_555d62e4_fk_paiyroll_ FOREIGN KEY (companybankdetail_ptr_id) REFERENCE=
S public.paiyroll_companybankdetail(polymorphicmodel_ptr_id) DEF<br>ERRABLE=
 INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5208; 2606 81014 FK CONSTRAINT paiyroll_comp=
anybankdetailgb paiyroll_companybank_companybankdetail_pt_5cf33abb_fk_paiyr=
oll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panybankdetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companybankdetailgb
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companybank_companybankdetai=
l_pt_5cf33abb_fk_paiyroll_ FOREIGN KEY (companybankdetail_ptr_id) REFERENCE=
S public.paiyroll_companybankdetail(polymorphicmodel_ptr_id) DEF<br>ERRABLE=
 INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5206; 2606 81019 FK CONSTRAINT paiyroll_comp=
anybankdetail paiyroll_companybank_polymorphicmodel_ptr_d05e0f06_fk_paiyrol=
l_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companybankdetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companybank_polymorphicmodel=
_ptr_d05e0f06_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES=
 public.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFER<br>RED;
<br>
<br>
<br>pg_restore: from TOC entry 5213; 2606 81029 FK CONSTRAINT paiyroll_comp=
anypostaldetailgb paiyroll_companypost_companypostaldetail__86015d44_fk_pai=
yroll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panypostaldetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailgb
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companypost_companypostaldet=
ail__86015d44_fk_paiyroll_ FOREIGN KEY (companypostaldetail_ptr_id) REFEREN=
CES public.paiyroll_companypostaldetail(polymorphicmodel_ptr_id)<br> DEFERR=
ABLE INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5214; 2606 81034 FK CONSTRAINT paiyroll_comp=
anypostaldetailus paiyroll_companypost_companypostaldetail__963c29cd_fk_pai=
yroll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panypostaldetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailus
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companypost_companypostaldet=
ail__963c29cd_fk_paiyroll_ FOREIGN KEY (companypostaldetail_ptr_id) REFEREN=
CES public.paiyroll_companypostaldetail(polymorphicmodel_ptr_id)<br> DEFERR=
ABLE INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5212; 2606 81039 FK CONSTRAINT paiyroll_comp=
anypostaldetailde paiyroll_companypost_companypostaldetail__f51f0ce0_fk_pai=
yroll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panypostaldetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetailde
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companypost_companypostaldet=
ail__f51f0ce0_fk_paiyroll_ FOREIGN KEY (companypostaldetail_ptr_id) REFEREN=
CES public.paiyroll_companypostaldetail(polymorphicmodel_ptr_id)<br> DEFERR=
ABLE INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5211; 2606 81044 FK CONSTRAINT paiyroll_comp=
anypostaldetail paiyroll_companypost_polymorphicmodel_ptr_d9fc1568_fk_paiyr=
oll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companypostaldetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companypost_polymorphicmodel=
_ptr_d9fc1568_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES=
 public.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFER<br>RED;
<br>
<br>
<br>pg_restore: from TOC entry 5217; 2606 81054 FK CONSTRAINT paiyroll_comp=
anytaxdetailde paiyroll_companytaxd_companytaxdetail_ptr_6509fa4d_fk_paiyro=
ll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panytaxdetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailde
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companytaxd_companytaxdetail=
_ptr_6509fa4d_fk_paiyroll_ FOREIGN KEY (companytaxdetail_ptr_id) REFERENCES=
 public.paiyroll_companytaxdetail(polymorphicmodel_ptr_id) DEFER<br>RABLE I=
NITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5219; 2606 81059 FK CONSTRAINT paiyroll_comp=
anytaxdetailus paiyroll_companytaxd_companytaxdetail_ptr_b8b74e53_fk_paiyro=
ll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panytaxdetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailus
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companytaxd_companytaxdetail=
_ptr_b8b74e53_fk_paiyroll_ FOREIGN KEY (companytaxdetail_ptr_id) REFERENCES=
 public.paiyroll_companytaxdetail(polymorphicmodel_ptr_id) DEFER<br>RABLE I=
NITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5218; 2606 81064 FK CONSTRAINT paiyroll_comp=
anytaxdetailgb paiyroll_companytaxd_companytaxdetail_ptr_d9437c9a_fk_paiyro=
ll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_com=
panytaxdetail&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetailgb
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companytaxd_companytaxdetail=
_ptr_d9437c9a_fk_paiyroll_ FOREIGN KEY (companytaxdetail_ptr_id) REFERENCES=
 public.paiyroll_companytaxdetail(polymorphicmodel_ptr_id) DEFER<br>RABLE I=
NITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5216; 2606 81069 FK CONSTRAINT paiyroll_comp=
anytaxdetail paiyroll_companytaxd_polymorphicmodel_ptr_41f5cde7_fk_paiyroll=
_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_companytaxdetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_companytaxd_polymorphicmodel=
_ptr_41f5cde7_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES=
 public.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFER<br>RED;
<br>
<br>
<br>pg_restore: from TOC entry 5221; 2606 81079 FK CONSTRAINT paiyroll_debb=
ie paiyroll_debbie_polymorphicmodel_ptr_8b0fe25a_fk_paiyroll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_debbie
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_debbie_polymorphicmodel_ptr_=
8b0fe25a_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES publ=
ic.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: from TOC entry 5234; 2606 81159 FK CONSTRAINT paiyroll_empl=
oyeebankdetail paiyroll_employeeban_polymorphicmodel_ptr_6b4ae3ff_fk_paiyro=
ll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_employeebankdetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_employeeban_polymorphicmodel=
_ptr_6b4ae3ff_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES=
 public.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFER<br>RED;
<br>
<br>
<br>pg_restore: from TOC entry 5239; 2606 81184 FK CONSTRAINT paiyroll_empl=
oyeepostaldetail paiyroll_employeepos_polymorphicmodel_ptr_4b75f2aa_fk_paiy=
roll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_employeepostaldetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_employeepos_polymorphicmodel=
_ptr_4b75f2aa_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES=
 public.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFER<br>RED;
<br>
<br>
<br>pg_restore: from TOC entry 5249; 2606 81229 FK CONSTRAINT paiyroll_empl=
oyeetaxeedetail paiyroll_employeetax_polymorphicmodel_ptr_2554ee34_fk_paiyr=
oll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_employeetaxeedetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_employeetax_polymorphicmodel=
_ptr_2554ee34_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES=
 public.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFER<br>RED;
<br>
<br>
<br>pg_restore: from TOC entry 5244; 2606 81234 FK CONSTRAINT paiyroll_empl=
oyeetaxdetail paiyroll_employeetax_polymorphicmodel_ptr_8c064f71_fk_paiyrol=
l_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_employeetaxdetail
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_employeetax_polymorphicmodel=
_ptr_8c064f71_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES=
 public.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFER<br>RED;
<br>
<br>
<br>pg_restore: from TOC entry 5258; 2606 81264 FK CONSTRAINT paiyroll_miss=
ing paiyroll_missing_polymorphicmodel_ptr_a1958c79_fk_paiyroll_ dbcoreuser
<br>pg_restore: error: could not execute query: ERROR: =C2=A0there is no un=
ique constraint matching given keys for referenced table &quot;paiyroll_pol=
ymorphicmodel&quot;
<br>Command was: ALTER TABLE ONLY public.paiyroll_missing
<br> =C2=A0=C2=A0=C2=A0ADD CONSTRAINT paiyroll_missing_polymorphicmodel_ptr=
_a1958c79_fk_paiyroll_ FOREIGN KEY (polymorphicmodel_ptr_id) REFERENCES pub=
lic.paiyroll_polymorphicmodel(id) DEFERRABLE INITIALLY DEFERRED;
<br>
<br>
<br>pg_restore: warning: errors ignored on restore: 26<br></span></div><div=
>=3D=3D=3D=3D=3D=3D=3D=3D<br></div></div></div>

--0000000000005d45f8061b7d817d--