Can't find postgres sequences for registered tables

594
2
Jump to solution
02-09-2022 02:53 PM
NickRobles
New Contributor II

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

 

0 Kudos
1 Solution

Accepted Solutions
NickRobles
New Contributor II

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 

View solution in original post

0 Kudos
2 Replies
NickRobles
New Contributor II

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

0 Kudos
NickRobles
New Contributor II

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 

0 Kudos