ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS 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
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

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

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal