The following error message is returned when restoring the PostgreSQL geodatabase, "Error: relation"sde.sde_coordinate_systems"does not exist Command was: ALTER TABLE ONLY public.sde_spatial_references ADD CONSTRAINT spatial_ref_fk1 FOREIGN KEY (cs_id) REFERENCES sde.sde_coordinate_systems(id);"
上次发布: March 24, 2022ArcGIS for Desktop
漏洞 ID 编号
BUG-000145631
已提交
December 28, 2021
上次修改时间
June 5, 2024
适用范围
ArcGIS for Desktop
找到的版本
10.8.1
操作系统
Windows OS
操作系统版本
N/A
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
The behavior is not happening as a result of ArcGIS but with pg_restore. In order to restore, it must be done with -n switches for public and sde in the same command. For example: pg_restore -U postgres -d snoopynetst1 -n public,sde dump1.dmp