topic Subtypes and PostgreSQL - Attribute column not found in Data Management Questions https://community.esri.com/t5/data-management-questions/subtypes-and-postgresql-attribute-column-not-found/m-p/35836#M2007 <HTML><HEAD></HEAD><BODY><SPAN>Original User: johnjreiser</SPAN><BR /><BR /><SPAN>Has anyone had any issues creating a subtype in a 9.3 SDE Geodatabase that uses PostgreSQL as the backend?</SPAN><BR /><BR /><SPAN>Here's what's happening: I have an "interior" (interior spaces) polygon feature class within my facilities feature dataset. Within "interior" I have a "floor" field that I would like to use as a subtype. I tried setting the subtype field from both the Subtypes tab from within the Feature Class Properties window and the Set Subtype Field toolbox function. I also thought that "interior" and "floor" might be reserved words, so I also tried this with a feature class "spaces" and field name of "flr". The same error message occurs.</SPAN><BR /><BR /><SPAN>The database is running on PostgreSQL 8.3.11 and is ArcSDE 9.3. I am planning to migrate this whole DB over to 8.4/SDE10 in the next few weeks, so if this is just a 9.3 bug, wonderful. I'm connecting to the DB using ArcGIS Desktop 10, Service Pack 3. </SPAN><BR /><BR /><SPAN>Any help or guidance is greatly appreciated!</SPAN><BR /><BR /><SPAN>Take care,</SPAN><BR /><SPAN>John</SPAN></BODY></HTML> Wed, 11 Jan 2012 22:06:00 GMT Anonymous User 2012-01-11T22:06:00Z Subtypes and PostgreSQL - Attribute column not found https://community.esri.com/t5/data-management-questions/subtypes-and-postgresql-attribute-column-not-found/m-p/35836#M2007 <HTML><HEAD></HEAD><BODY><SPAN>Original User: johnjreiser</SPAN><BR /><BR /><SPAN>Has anyone had any issues creating a subtype in a 9.3 SDE Geodatabase that uses PostgreSQL as the backend?</SPAN><BR /><BR /><SPAN>Here's what's happening: I have an "interior" (interior spaces) polygon feature class within my facilities feature dataset. Within "interior" I have a "floor" field that I would like to use as a subtype. I tried setting the subtype field from both the Subtypes tab from within the Feature Class Properties window and the Set Subtype Field toolbox function. I also thought that "interior" and "floor" might be reserved words, so I also tried this with a feature class "spaces" and field name of "flr". The same error message occurs.</SPAN><BR /><BR /><SPAN>The database is running on PostgreSQL 8.3.11 and is ArcSDE 9.3. I am planning to migrate this whole DB over to 8.4/SDE10 in the next few weeks, so if this is just a 9.3 bug, wonderful. I'm connecting to the DB using ArcGIS Desktop 10, Service Pack 3. </SPAN><BR /><BR /><SPAN>Any help or guidance is greatly appreciated!</SPAN><BR /><BR /><SPAN>Take care,</SPAN><BR /><SPAN>John</SPAN></BODY></HTML> Wed, 11 Jan 2012 22:06:00 GMT https://community.esri.com/t5/data-management-questions/subtypes-and-postgresql-attribute-column-not-found/m-p/35836#M2007 Anonymous User 2012-01-11T22:06:00Z