Arsthbt

Multi tool use

How can Trident be so inexpensive? Will it orbit Triton or just do a (slow) flyby?

Does having a TSA Pre-Check member in your flight reservation increase the chances that everyone gets Pre-Check?

Is it improper etiquette to ask your opponent what his/her rating is before the game?

Why did the EU agree to delay the Brexit deadline?

Visiting the UK as unmarried couple

Why did the HMS Bounty go back to a time when whales are already rare?

Is possible to search in vim history?

Divine apple island

Is XSS in canonical link possible?

Should I stop contributing to retirement accounts?

API Access HTML/Javascript

Flux received by a negative charge

Do Legal Documents Require Signing In Standard Pen Colors?

Will adding a BY-SA image to a blog post make the entire post BY-SA?

Is it possible to have a strip of cold climate in the middle of a planet?

Can I use my Chinese passport to enter China after I acquired another citizenship?

Freedom of speech and where it applies

Why do IPv6 unique local addresses have to have a /48 prefix?

Can a significant change in incentives void an employment contract?

When quoting, must I also copy hyphens used to divide words that continue on the next line?

Have I saved too much for retirement so far?

What is the gram­mat­i­cal term for “‑ed” words like these?

How can "mimic phobia" be cured or prevented?

My friend sent me a screenshot of a transaction hash, but when I search for it I find divergent data. What happened?

ArcGIS not connecting to PostgreSQL db with all upper-case name

Direct connecting to PostgreSQL from ArcGIS Desktop?Connecting to ArcGIS Desktop PostgreSQL database (running locally)Using PostgreSQL with ArcGISQuery layer in ArcGIS Desktop with PostgreSQL not querying data?Database access pattern using PostgreSQL and ArcGISRemove upper case in column names in a PostGIS spatial table to permit use in ArcMapConnecting Django to postgresqlConnecting ArcGIS Desktop to remote PostgreSQL database?Error restoring spatial database. ERROR : could not load library “/builds/postgresql-9.6.3/lib/rtpostgis-2.3.so”ArcGIS Pro connection to PostgreSQL Database

1

We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.

We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.

And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.

So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?

arcgis-desktop postgresql database

share|improve this question

edited 3 hours ago

Vince

14.8k32749

asked 5 hours ago

user25730user25730

152110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
  
  – Michael Stimson
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
  
  – user25730
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
  
  – Michael Stimson
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
  
  – Vince
  3 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
  
  – Michael Stimson
  1 hour ago
  

  
  
  
  

 | 
show 1 more comment

1

We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.

We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.

And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.

So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?

arcgis-desktop postgresql database

share|improve this question

edited 3 hours ago

Vince

14.8k32749

asked 5 hours ago

user25730user25730

152110

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What version of ArcGIS desktop are you using? (yes, it's important) Have you installed the Postgres client? It is true that postgres prefers all lower case, when you do rename the database does ArcGIS then connect? Perhaps you could post on dba.stackexchange.com to see if there's a possibility of mirroring/aliasing GISSTUFF as esrigisstuff just for Esri users to connect (same database, different name).
  
  – Michael Stimson
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I was thinking about mirroring / aliasing. May give that a go. I don't know the other things as the ArcGIS trial has expired. It would be the latest. I'm just doing barebones Postgres admin using pgadmin III.
  
  – user25730
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That makes it kind of hard to test the connection if your Esri trial has expired. Mirroring/aliasing might work but may not, the mirror might be looking for a schema esrigisstuff in the GISSTUFF database which wont exist... I'm predominantly an Esri user so I setup PostGIS specifically for Esri and it's just a bonus that other software will connect to it; A warning though, having mixed editors is a very bad idea, if you want to edit in QGIS do so, but don't edit with Esri and visa versa.
  
  – Michael Stimson
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  There is no way to make ArcGIS use uppercase database names. Period. Not since SDBE 1.2.1, at least (excepting Oracle databases, which could only be uppercase).
  
  – Vince
  3 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you have a reference for that @Vince? If so it would make an excellent answer/warning for users who wish to use PostGIS with ArcGIS... though I would also be interested to see if a database could be successfully aliased or mirrored with a lower case name.
  
  – Michael Stimson
  1 hour ago
  

  
  
  
  

 | 
show 1 more comment

We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.

We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.

And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.

So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?

arcgis-desktop postgresql database

share|improve this question

edited 3 hours ago

Vince

14.8k32749

asked 5 hours ago

user25730user25730

152110

share|improve this question

edited 3 hours ago

Vince

14.8k32749

asked 5 hours ago

user25730user25730

152110

share|improve this question

edited 3 hours ago

Vince

14.8k32749

asked 5 hours ago

user25730user25730

152110

edited 3 hours ago

Vince

14.8k32749

edited 3 hours ago

Vince

14.8k32749

asked 5 hours ago

user25730user25730

152110

asked 5 hours ago

user25730user25730

152110

1 Answer
1

active

oldest

votes

2

It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.

The Desktop documentation states (emphasis mine):

Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.

And the Server documentation says the same (ditto):

Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.

With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.

share|improve this answer

answered 53 mins ago

VinceVince

14.8k32749

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f316512%2farcgis-not-connecting-to-postgresql-db-with-all-upper-case-name%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.

The Desktop documentation states (emphasis mine):

Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.

And the Server documentation says the same (ditto):

Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.

With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.

share|improve this answer

answered 53 mins ago

VinceVince

14.8k32749

add a comment | 

2

It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.

The Desktop documentation states (emphasis mine):

Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.

And the Server documentation says the same (ditto):

Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.

With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.

share|improve this answer

answered 53 mins ago

VinceVince

14.8k32749

add a comment | 

It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names. ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.

The Desktop documentation states (emphasis mine):

Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.

And the Server documentation says the same (ditto):

Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.

With tables and columns, you can create views to work around naming issues. But with databases, no connection is possible, so you never get that chance.

share|improve this answer

answered 53 mins ago

VinceVince

14.8k32749

share|improve this answer

answered 53 mins ago

VinceVince

14.8k32749

answered 53 mins ago

VinceVince

14.8k32749

answered 53 mins ago

VinceVince

14.8k32749