topic Can't find postgres sequences for registered tables in ArcGIS Pro Questions

Can't find postgres sequences for registered tables

NickRobles — Wed, 09 Feb 2022 23:29:41 GMT

After registering a table with a geodatabase, I can see in the sde.sde_table_registry table that the table was registered and that the table also has the objectid column added and populated. However, when I try to search for the sequence under the name 'r + <registration_id>', I can only find the 'r + <regsitration_id> + _sde_rowid_uk' index.

In oracle, I am able to find the sequence as expected.

Is there a query that someone can send me to definitively check for the sequence? I am searching in

pg_class

and

information_schema.sequences

Re: Can't find postgres sequences for registered tables

NickRobles — Thu, 10 Feb 2022 19:53:11 GMT

so far I have been able to see that on initial registration of a table, a temporary sequence is created, the objectid field is added, and then that field is populated using the temp sequence before dropping the temp sequence. Still have not found the sequence being used when adding a new record to that table

Re: Can't find postgres sequences for registered tables

NickRobles — Thu, 10 Feb 2022 21:50:16 GMT

ok, well it seems that sometime after 10.6.1+ , the format for sequences as r<reg_id> was dropped in postgres as it was not very efficient.

https://gis.stackexchange.com/questions/266461/arcgis-sde-i5-i6-i7-tables

Instead, these i<reg_id> tables are created to manage objectids