Select to view content in your preferred language

The table does not have an OID field after upgrade

06-17-2024 02:50 PM
Occasional Contributor II

We recently updated our GIS stacks which necessitated upgrading the Postgres versions, as well. We followed the guidelines to do a pg_dump and pg_restore and read the documentation that stated that OIDs are not supported with newer versions of Postgres. However, when we try to do anything in the database, we are unable to. For instance, if we try to add a new feature class, we receive a an ERROR 160332: The table does not have an OID Field. Well, we know this. It also prohibits us from taking maps that use the database as a datastore offline and so on and so forth.

Is there a fix to this?

0 Kudos
0 Replies