AnsweredAssumed Answered

Can't create feature class with PG_GEOMETRY keyword

Question asked by gispro_new on Apr 30, 2015
Latest reply on Oct 18, 2015 by cspoerri

I have enabled a PostgreSQL database as an enterprise geodatabase with ArcCatalog (using server license file etc).

When I create a new feature class with PG_GEOMETRY keyword, I get an error: ERROR: constraint "enforce_dims_shape" of relation "newclass" does not exist.

Newclass is the name of the feature class I'm trying to create. I guess for some reason ArcGIS can't create this constraint when creating a table in DB, or it just doesn't create it, and then looks for it.

I'm able to create tables and constraints with pgAdmin, connecting as an "sde" user and "postgres" user. ArcCatalog connection is set up to use "sde" user.

I have postgis extension installed in a DB, so I can create geometry type columns with pgAdmin.

I'm running PostgreSQL 9.3.5 + PostGIS 2.1.

 

When creating a feature class without PG_GEOMETRY keyword, it's being created with no problems as expected.

But I need postgis geometry type, so I can edit geometry data from ArcGIS and some other software. What should I do to create a new empty feature class with postgis geometry?

Outcomes