topic Re: get sequence nextval in postgres in ArcObjects SDK Questions

get sequence nextval in postgres

Anonymous User — Fri, 21 Jan 2011 18:05:42 GMT

Original User: dwoods

I have been using the C# code sample that uses IQueryDef to get the nextval from a sequence in our Oracle database. Now I am trying to port the code to postgres. I would prefer to keep it in ArcObjects rather than make a db connection and run it in PostgreSQL. Does anyone have a working code snippet? I have tried many variations with the original code sample to no avail. This is what I was using in Oracle:

            IFeatureWorkspace featureWorkspace = workspace as IFeatureWorkspace;
            IQueryDef queryDef;
            ICursor cursor;
            IRow row;
            double seqValue;

            queryDef = featureWorkspace.CreateQueryDef();
            queryDef.SubFields = "owner.seq_name.nextval";
            queryDef.Tables = "sys.dual";
            cursor = queryDef.Evaluate();
            row = cursor.NextRow();
            seqValue = double.Parse(row.get_Value(0).ToString());

Re: get sequence nextval in postgres

Anonymous User — Mon, 24 Jan 2011 03:58:18 GMT

Original User: vtammineni

I have been using the C# code sample that uses IQueryDef to get the nextval from a sequence in our Oracle database. Now I am trying to port the code to postgres. I would prefer to keep it in ArcObjects rather than make a db connection and run it in PostgreSQL. Does anyone have a working code snippet? I have tried many variations with the original code sample to no avail. This is what I was using in Oracle:

            IFeatureWorkspace featureWorkspace = workspace as IFeatureWorkspace;
            IQueryDef queryDef;
            ICursor cursor;
            IRow row;
            double seqValue;

            queryDef = featureWorkspace.CreateQueryDef();
            queryDef.SubFields = "owner.seq_name.nextval";
            queryDef.Tables = "sys.dual";
            cursor = queryDef.Evaluate();
            row = cursor.NextRow();
            seqValue = double.Parse(row.get_Value(0).ToString());

You are using Postgresql ArcSDE ?

Re: get sequence nextval in postgres

Anonymous User — Mon, 24 Jan 2011 11:10:15 GMT

Original User: dwoods

Yes. Postgresql version 8.3.7 and ArcSDE vers 9.3 sp1.