ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

00157: The published layer's data source will be PostgreSQL and the layer uses field names that are not lower case used in <value>

  • Solution
  • More information

You are publishing a map services with either Feature Access (feature service) or WFS capabilities where the service layer's data source will be a PostgreSQL geodatabase and the layer uses field name that are not lowercased in the following:

  • A definition query
  • A label expression
  • Both a definition query and a label expression

The area affected is indicated by the <value> parameter.

Solution

Change your expression such that all field names use lowercase. For example, change [MyField] > 100 to [myfield] > 100.

Note:

If you are changing label expressions, make sure you change expressions for all appropriate label classes.

More information

Field names are always lowercase in PostgreSQL geodatabases. Definition queries and label expressions must use lowercase field names if they are to work with PostgreSQL geodatabases.

Learn more about geodatabases in PostgreSQL

Definition queries are used to display a subset of features in a layer.

Learn more about definition queries

Label expressions are used to customize the text string of your labels.

Learn more about label expressions

Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal