Postgres sequences using feature service

kirken — Sun, 23 Oct 2022 09:27:42 GMT

Hello!

I'm developing an add-in where I'm using ArcGIS Feature Service from Portal that has one layer and some tables related to it. Data is in Postgres database. I would like to know how to query sequence table. Does sequence table has to be added to service for that? Before starting to use feature service I queried sequences like in the code example below:

using (var tbl = f_layer.GetTable()) { seqs = FaktikaUtils.GetAllSequences(tbl); } public static List<string> GetAllSequences(Table Tbl) { List<string> seq_lst = new List<string>(); using (Geodatabase gdb = Tbl.GetDatastore() as Geodatabase) { if (gdb.GetGeodatabaseType() == GeodatabaseType.RemoteDatabase)) { var conn = gdb.GetConnector() as DatabaseConnectionProperties; if (conn.DBMS == EnterpriseDatabaseType.PostgreSQL) { QueryDef qd = new QueryDef { Tables = "information_schema.sequences", SubFields = "sequence_name, sequence_catalog, sequence_schema" }; using (RowCursor cur = gdb.Evaluate(qd, false)) { while (cur.MoveNext()) { using (Row row = cur.Current) { seq_lst.Add($"{row["sequence_catalog"]}.{row["sequence_schema"]}.{row["sequence_name"]}"); } } } } } } return seq_lst; }

Re: Postgres sequences using feature service

RichRuh — Tue, 25 Oct 2022 23:04:58 GMT

One thing you might consider is whether you can use attribute rules to generate the sequence.

If you want to stick to the way you are doing it, you might create a registered view on the sequence table. Then you would add that view to your publishing map and republish it with your service.

I hope this helps,

--Rich

topic Re: Postgres sequences using feature service in ArcGIS Pro SDK Questions

Postgres sequences using feature service

Re: Postgres sequences using feature service