Bug
When creating a new feature class and specifying a 'Mercator (World)' or 'WGS 1984 Web Mercator’ projected coordinate system using the PG_GEOMETRY geometry type in a POSTGIS 1.4 enabled spatial database, the following error is received: "‘Failed to create feature class. Underlying DBMS error[ERROR: AddGeometryColumns() – invalid SRID CONNECT: SQL statement “SELECT AddGeometryColumn(“,$1 , $2 , $3 , $4 , $5 , $6 )”PL/pgsql function “addgeometrycolumn” line 5 at SQL statement::SQL state: P0001"
| Bug ID Number | NIM051648 |
|---|---|
| Submitted | December 3, 2009 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.0 Beta |
| Operating System | Windows OS |
| Operating System Version | 2008 |
| Version Fixed | N/A |
| Status | Fixed |
Additional Information
You need to grant the user as whom you are trying to load the data SELECT privileges on public.spatial_ref_sys table.Steps to Reproduce
Bug ID: NIM051648
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App