Command was: ALTER TABLE ONLY surveypoint ADD CONSTRAINT locality_surveypoint FOREIGN KEY (locality_id) REFERENCES loc ality(locality_... pg_restore: [archiver (db)] Error from TOC entry 3698; 2606 305856 FK CONSTRAINT macro_lookupgr_macroscopic postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "macro_l ookupgr_macroscopic" for relation "macroscopic" already exists Command was: ALTER TABLE ONLY macroscopic ADD CONSTRAINT macro_lookupgr_macroscopic FOREIGN KEY (grain_id) REFERENCES grain_lookup(gr... pg_restore: [archiver (db)] Error from TOC entry 3699; 2606 305861 FK CONSTRAINT macro_lookuplu_macroscopic postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "macro_l ookuplu_macroscopic" for relation "macroscopic" already exists Command was: ALTER TABLE ONLY macroscopic ADD CONSTRAINT macro_lookuplu_macroscopic FOREIGN KEY (lustre_id) REFERENCES lustre_lookup(... pg_restore: [archiver (db)] Error from TOC entry 3700; 2606 305866 FK CONSTRAINT macro_lookuptr_macroscopic postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "macro_l ookuptr_macroscopic" for relation "macroscopic" already exists Command was: ALTER TABLE ONLY macroscopic ADD CONSTRAINT macro_lookuptr_macroscopic FOREIGN KEY (translucency_id) REFE RENCES transluc... pg_restore: [archiver (db)] Error from TOC entry 3671; 2606 248648 FK CONSTRAINT material_arcsample postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "materia l_arcsample" for relation "arcsample" already exists Command was: ALTER TABLE ONLY arcsample ADD CONSTRAINT material_arcsample FOREIGN KEY (material_id) REFERENCES mater ial(material_id) ... pg_restore: [archiver (db)] Error from TOC entry 3703; 2606 248653 FK CONSTRAINT material_sample postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "materia l_sample" for relation "sample" already exists Command was: ALTER TABLE ONLY sample ADD CONSTRAINT material_sample FOREIGN KEY (material_id) REFERENCES material (material_id) ON UPD... pg_restore: [archiver (db)] Error from TOC entry 3692; 2606 248658 FK CONSTRAINT reference_formation_reference postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "referen ce_formation_reference" for relation "formation_reference" already exists Command was: ALTER TABLE ONLY formation_reference ADD CONSTRAINT reference_formation_reference FOREIGN KEY (reference_id) REFE RENCES ... pg_restore: [archiver (db)] Error from TOC entry 3710; 2606 248663 FK CONSTRAINT reference_reference_sample postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "referen ce_reference_sample" for relation "reference_sample" already exists Command was: ALTER TABLE ONLY reference_sample ADD CONSTRAINT reference_reference_sample FOREIGN KEY (reference_id) REFEREN CES refere... pg_restore: [archiver (db)] Error from TOC entry 3704; 2606 248668 FK CONSTRAINT sample_formation postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "sample_ formation" for relation "sample" already exists Command was: ALTER TABLE ONLY sample ADD CONSTRAINT sample_formation FOREIGN KEY (formation_id) REFERENCES format ion(formation_id) ON... pg_restore: [archiver (db)] Error from TOC entry 3694; 2606 248673 FK CONSTRAINT sample_geochemical postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "sample_ geochemical" for relation "geochemical" already exists Command was: ALTER TABLE ONLY geochemical ADD CONSTRAINT sample_geochemical FOREIGN KEY (sample_id) REFERENCES sample( sample_id) ON U... pg_restore: [archiver (db)] Error from TOC entry 3697; 2606 248683 FK CONSTRAINT sample_macroscopic postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "sample_ macroscopic" for relation "macroscopic" already exists Command was: ALTER TABLE ONLY macroscopic ADD CONSTRAINT sample_macroscopic FOREIGN KEY (sample_id) REFERENCES sample( sample_id) ON U... pg_restore: [archiver (db)] Error from TOC entry 3702; 2606 248688 FK CONSTRAINT sample_microscopic postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "sample_ microscopic" for relation "microscopic" already exists Command was: ALTER TABLE ONLY microscopic ADD CONSTRAINT sample_microscopic FOREIGN KEY (sample_id) REFERENCES sample( sample_id) ON U... pg_restore: [archiver (db)] Error from TOC entry 3711; 2606 248693 FK CONSTRAINT sample_reference_sample postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "sample_ reference_sample" for relation "reference_sample" already exists Command was: ALTER TABLE ONLY reference_sample ADD CONSTRAINT sample_reference_sample FOREIGN KEY (sample_id) REFERENCES sa mple(sampl... pg_restore: [archiver (db)] Error from TOC entry 3705; 2606 248698 FK CONSTRAINT sample_sample_type postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "sample_ sample_type" for relation "sample" already exists Command was: ALTER TABLE ONLY sample ADD CONSTRAINT sample_sample_type FOREIGN KEY (sample_type_id) REFERENCES sa mple_type(sample_typ... pg_restore: [archiver (db)] Error from TOC entry 3706; 2606 248703 FK CONSTRAINT sample_surveypoint postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "surveypoi nt" does not exist Command was: ALTER TABLE ONLY sample ADD CONSTRAINT sample_surveypoint FOREIGN KEY (surveypoint_id) REFERENCES su rveypoint(surveypoin... pg_restore: [archiver (db)] Error from TOC entry 3712; 2606 248708 FK CONSTRAINT surveyor_id postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "surveyo r_id" for relation "surveyor_survypnt_junc" already exists Command was: ALTER TABLE ONLY surveyor_survypnt_junc ADD CONSTRAINT surveyor_id FOREIGN KEY (surveyor_id) REFERENCES surveyor(sur veyo... pg_restore: [archiver (db)] Error from TOC entry 3713; 2606 248713 FK CONSTRAINT surveypoint_id postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "surveypoi nt" does not exist Command was: ALTER TABLE ONLY surveyor_survypnt_junc ADD CONSTRAINT surveypoint_id FOREIGN KEY (surveypoint_id) REFERENCES survey poin... pg_restore: [archiver (db)] Error from TOC entry 3679; 2606 248723 FK CONSTRAINT surveypoint_type_arcsurveypoint postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "arcsurvey point" does not exist Command was: ALTER TABLE ONLY arcsurveypoint ADD CONSTRAINT surveypoint_type_arcsurveypoint FOREIGN KEY (surveypoint_type _id) REFEREN... pg_restore: [archiver (db)] Error from TOC entry 3689; 2606 248728 FK CONSTRAINT surveypoint_type_surveypoint postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "surveypoi nt" does not exist Command was: ALTER TABLE ONLY surveypoint ADD CONSTRAINT surveypoint_type_surveypoint FOREIGN KEY (surveypoint_type_id ) REFERENCES su... pg_restore: [archiver (db)] Error from TOC entry 3709; 2606 248815 FK CONSTRAINT svy_sam_image_junc_sample postgres pg_restore: [archiver (db)] could not execute query: ERROR: constraint "svy_sam _image_junc_sample" for relation "svy_sam_image_junc" already exists Command was: ALTER TABLE ONLY svy_sam_image_junc ADD CONSTRAINT svy_sam_image_junc_sample FOREIGN KEY (sample_id) REFERENCES sample(s... pg_restore: [archiver (db)] Error from TOC entry 3708; 2606 248733 FK CONSTRAINT svy_sam_image_junc_surveypoint postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "surveypoi nt" does not exist Command was: ALTER TABLE ONLY svy_sam_image_junc ADD CONSTRAINT svy_sam_image_junc_surveypoint FOREIGN KEY (surveypoint_id) R EFERENCE... pg_restore: [archiver (db)] Error from TOC entry 3680; 2606 248738 FK CONSTRAINT townlands_arcsurveypoint postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "arcsurvey point" does not exist Command was: ALTER TABLE ONLY arcsurveypoint ADD CONSTRAINT townlands_arcsurveypoint FOREIGN KEY (twnlnd_id) REFERENCES t ownlands(twn... pg_restore: [archiver (db)] Error from TOC entry 3690; 2606 248743 FK CONSTRAINT townlands_surveypoint postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "surveypoi nt" does not exist Command was: ALTER TABLE ONLY surveypoint ADD CONSTRAINT townlands_surveypoint FOREIGN KEY (twnlnd_id) REFERENCES town lands(twnlnd_id... pg_restore: [archiver (db)] Error from TOC entry 3962; 0 0 ACL ni10k_bdrck postg res pg_restore: [archiver (db)] could not execute query: ERROR: relation "ni10k_bdr ck" does not exist Command was: REVOKE ALL ON TABLE ni10k_bdrck FROM PUBLIC; REVOKE ALL ON TABLE ni10k_bdrck FROM postgres; GRANT ALL ON TABLE ni10k_bdrck T... pg_restore: [archiver (db)] Error from TOC entry 3964; 0 0 ACL ni250k_bdrck_geol postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "ni250k_bd rck_geol" does not exist Command was: REVOKE ALL ON TABLE ni250k_bdrck_geol FROM PUBLIC; REVOKE ALL ON TABLE ni250k_bdrck_geol FROM postgres; GRANT ALL ON TABLE n... pg_restore: [archiver (db)] Error from TOC entry 3966; 0 0 ACL ni250k_bdrck_line postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "ni250k_bd rck_line" does not exist Command was: REVOKE ALL ON TABLE ni250k_bdrck_line FROM PUBLIC; REVOKE ALL ON TABLE ni250k_bdrck_line FROM postgres; GRANT ALL ON TABLE n... pg_restore: [archiver (db)] Error from TOC entry 3968; 0 0 ACL ni250k_surfic_geo l postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "ni250k_su rfic_geol" does not exist Command was: REVOKE ALL ON TABLE ni250k_surfic_geol FROM PUBLIC; REVOKE ALL ON TABLE ni250k_surfic_geol FROM postgres; GRANT ALL ON TABLE... pg_restore: [archiver (db)] Error from TOC entry 3970; 0 0 ACL rcregg3b2 postgre s pg_restore: [archiver (db)] could not execute query: ERROR: relation "rcregg3b2 " does not exist Command was: REVOKE ALL ON TABLE rcregg3b2 FROM PUBLIC; REVOKE ALL ON TABLE rcregg3b2 FROM postgres; GRANT ALL ON TABLE rcregg3b2 TO post... pg_restore: [archiver (db)] Error from TOC entry 3971; 0 0 ACL rcregg3b2_findspo t_num postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "rcregg3b2 _findspot_num" does not exist Command was: REVOKE ALL ON TABLE rcregg3b2_findspot_num FROM PUBLIC; REVOKE ALL ON TABLE rcregg3b2_findspot_num FROM postgres; GRANT ALL ... pg_restore: [archiver (db)] Error from TOC entry 3985; 0 0 ACL image_temp postgr es pg_restore: [archiver (db)] could not execute query: ERROR: relation "image_tem p" does not exist Command was: REVOKE ALL ON TABLE image_temp FROM PUBLIC; REVOKE ALL ON TABLE image_temp FROM postgres; GRANT ALL ON TABLE image_temp TO p... pg_restore: [archiver (db)] Error from TOC entry 3989; 0 0 ACL irlbeach_cret_che rt postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irlbeach_ cret_chert" does not exist Command was: REVOKE ALL ON TABLE irlbeach_cret_chert FROM PUBLIC; REVOKE ALL ON TABLE irlbeach_cret_chert FROM postgres; GRANT ALL ON TAB... pg_restore: [archiver (db)] Error from TOC entry 3991; 0 0 ACL irlcoast_surv pos tgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irlcoast_ surv" does not exist Command was: REVOKE ALL ON TABLE irlcoast_surv FROM PUBLIC; REVOKE ALL ON TABLE irlcoast_surv FROM postgres; GRANT ALL ON TABLE irlcoast_... pg_restore: [archiver (db)] Error from TOC entry 3992; 0 0 ACL irlcoast_surv_b15 k postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irlcoast_ surv_b15k" does not exist Command was: REVOKE ALL ON TABLE irlcoast_surv_b15k FROM PUBLIC; REVOKE ALL ON TABLE irlcoast_surv_b15k FROM postgres; GRANT ALL ON TABLE... pg_restore: [archiver (db)] Error from TOC entry 3995; 0 0 ACL irlcounty32_for_i rlarea_select postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irlcounty 32_for_irlarea_select" does not exist Command was: REVOKE ALL ON TABLE irlcounty32_for_irlarea_select FROM PUBLIC; REVOKE ALL ON TABLE irlcounty32_for_irlarea_select FROM post... pg_restore: [archiver (db)] Error from TOC entry 3996; 0 0 ACL irlcounty32_for_i rlarea_select2 postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irlcounty 32_for_irlarea_select2" does not exist Command was: REVOKE ALL ON TABLE irlcounty32_for_irlarea_select2 FROM PUBLIC ; REVOKE ALL ON TABLE irlcounty32_for_irlarea_select2 FROM po... pg_restore: [archiver (db)] Error from TOC entry 4000; 0 0 ACL irllakeshannon po stgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irllakesh annon" does not exist Command was: REVOKE ALL ON TABLE irllakeshannon FROM PUBLIC; REVOKE ALL ON TABLE irllakeshannon FROM postgres; GRANT ALL ON TABLE irllake... pg_restore: [archiver (db)] Error from TOC entry 4004; 0 0 ACL irlrivercorrib po stgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irlriverc orrib" does not exist Command was: REVOKE ALL ON TABLE irlrivercorrib FROM PUBLIC; REVOKE ALL ON TABLE irlrivercorrib FROM postgres; GRANT ALL ON TABLE irlrive... pg_restore: [archiver (db)] Error from TOC entry 4006; 0 0 ACL irlrivshannon pos tgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "irlrivsha nnon" does not exist Command was: REVOKE ALL ON TABLE irlrivshannon FROM PUBLIC; REVOKE ALL ON TABLE irlrivshannon FROM postgres; GRANT ALL ON TABLE irlrivsha... pg_restore: [archiver (db)] Error from TOC entry 4010; 0 0 ACL locality_temp pos tgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "locality_ temp" does not exist Command was: REVOKE ALL ON TABLE locality_temp FROM PUBLIC; REVOKE ALL ON TABLE locality_temp FROM postgres; GRANT ALL ON TABLE locality_... pg_restore: [archiver (db)] Error from TOC entry 4020; 0 0 ACL query_srpnt_sampl e_irll14 postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "query_srp nt_sample_irll14" does not exist Command was: REVOKE ALL ON TABLE query_srpnt_sample_irll14 FROM PUBLIC; REVOKE ALL ON TABLE query_srpnt_sample_irll14 FROM postgres; GRAN... pg_restore: [archiver (db)] Error from TOC entry 4021; 0 0 ACL query_srpnt_sampl e_macro_irll14 postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "query_srp nt_sample_macro_irll14" does not exist Command was: REVOKE ALL ON TABLE query_srpnt_sample_macro_irll14 FROM PUBLIC ; REVOKE ALL ON TABLE query_srpnt_sample_macro_irll14 FROM po... pg_restore: [archiver (db)] Error from TOC entry 4022; 0 0 ACL query_surv_sam_im age_irll14 postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "query_sur v_sam_image_irll14" does not exist Command was: REVOKE ALL ON TABLE query_surv_sam_image_irll14 FROM PUBLIC; REVOKE ALL ON TABLE query_surv_sam_image_irll14 FROM postgres; ... pg_restore: [archiver (db)] Error from TOC entry 4031; 0 0 ACL surveypoints_2015 postgres pg_restore: [archiver (db)] could not execute query: ERROR: relation "surveypoi nts_2015" does not exist Command was: REVOKE ALL ON TABLE surveypoints_2015 FROM PUBLIC; REVOKE ALL ON TABLE surveypoints_2015 FROM postgres; GRANT ALL ON TABLE s... WARNING: errors ignored on restore: 412 C:\Bitnami\wappstack-5.5.30-0\postgresql\bin>