laptop and a wrench

Bug

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);"

Last Published: March 24, 2022 ArcGIS for Desktop
Bug ID Number BUG-000145631
SubmittedDecember 28, 2021
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.8.1
Operating SystemWindows OS
Operating System VersionN/A
StatusWill Not Be Addressed

Additional Information

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

Steps to Reproduce

Bug ID: BUG-000145631

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options