AnsweredAssumed Answered

postgre enterprise SDE and arcmap - why do they open as query tables?

Question asked by yeel on Jun 1, 2016
Latest reply on Jun 28, 2016 by vangelo-esristaff

Hi, I've set up postgre /postgis and enterprise SDE. An example of my sql for setting up a table follows:

CREATE TABLE bird_sighting (
    bird_id integer PRIMARY KEY,
    field_id integer REFERENCES field(field_ID),
    birdev_id integer REFERENCES bird_event(birdev_id),
    sight_date date NOT NULL CHECK(sight_date > '2016-05-01'),
    activity character varying (30),
    rel_location character varying (20),
    species character varying (40),
    geom geometry(Point, 26917) NOT NULL
    );

 

When I open this feature class in ArcMap it opens up the "neq query layer" dialogue:

 

Is this correct? I thought that if I already defined the SRID and geometry type that this should already be populated?
Can someone explain to me why arcmap does this, or perhaps what I am doing wrong?

 

Thanks

Outcomes