Bug
Multi-versioned views must automatically access the ‘DEFAULT’ version after being created by the ‘sdetable -o create_mv_view -T test_mv_view –t’ command. This behavior is seen with ArcSDE for SQL Server and ArcSDE for Oracle where there is no need to set the current version. It automatically reads the changes made in the default version and displays the changes. In the case of PostgreSQL, it does not behave the same way. The current version must be set exclusively to default using the ‘sde.sde_set_current_version('DEFAULT')’ stored procedure.
| Bug ID Number | NIM074457 |
|---|---|
| Submitted | October 21, 2011 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.0 |
| Operating System | Windows OS |
| Operating System Version | 2008 64 Bit |
| Status | Known Limit |
Additional Information
Functionality not ported to this database due to limited requests. Commands sited no longer supported.Workaround
1. Set the version to DEFAULT by using the stored procedure select sde.sde_set_current_version('DEFAULT'); OR 2. Compress the geodatabase.Steps to Reproduce
Bug ID: NIM074457
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