ArcGIS not connecting to postgres db with all upper-case nameConnecting ArcGIS Desktop with PostGIS?Direct...
Extending the spectral theorem for bounded self adjoint operators to bounded normal operators
If a character with the Alert feat rolls a crit fail on their Perception check, are they surprised?
Can the Supreme Court overturn an impeachment?
Create all possible words using a set or letters
anything or something to eat
Drawing a topological "handle" with Tikz
Should I stop contributing to retirement accounts?
Greco-Roman egalitarianism
Have I saved too much for retirement so far?
Divine apple island
Does the Mind Blank spell prevent the target from being frightened?
Flux received by a negative charge
Will adding a BY-SA image to a blog post make the entire post BY-SA?
How to color a curve
Global amount of publications over time
Translation of Scottish 16th century church stained glass
How can Trident be so inexpensive? Will it orbit Triton or just do a (slow) flyby?
What's the difference between 違法 and 不法?
Visiting the UK as unmarried couple
What is the grammatical term for “‑ed” words like these?
Can a Necromancer reuse the corpses left behind from slain undead?
Diode in opposite direction?
Why we can't differentiate a polynomial equation as many times as we wish?
Engineer refusing to file/disclose patents
ArcGIS not connecting to postgres db with all upper-case name
Connecting ArcGIS Desktop with PostGIS?Direct connecting to PostgreSQL from ArcGIS Desktop?Using PostgreSQL with ArcGISHaving trouble connecting QGIS with postgres database with postgis extensionQGIS is not working with Postgres Plus Advanced ServerError while connecting qgis with postgres?Change case of Acronyms in PostGresRemove upper case in column names in a PostGIS spatial table to permit use in ArcMapCache not created on Geoserver with data from PostgresConnecting ArcGIS Desktop to remote PostgreSQL database?
We've been trialling ArcGIS at work and are just about to buy. However, we have a Postgres 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 Postgres databases in all upper-case?
arcgis-desktop postgresql database
asked 7 mins ago
user25730user25730
147110
add a comment |
We've been trialling ArcGIS at work and are just about to buy. However, we have a Postgres 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 Postgres databases in all upper-case?
arcgis-desktop postgresql database
asked 7 mins ago
user25730user25730
147110
add a comment |
We've been trialling ArcGIS at work and are just about to buy. However, we have a Postgres 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 Postgres databases in all upper-case?
arcgis-desktop postgresql database
asked 7 mins ago
user25730user25730
147110
We've been trialling ArcGIS at work and are just about to buy. However, we have a Postgres 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 Postgres databases in all upper-case?
arcgis-desktop postgresql database
arcgis-desktop postgresql database
asked 7 mins ago
user25730user25730
147110
asked 7 mins ago
user25730user25730
147110
asked 7 mins ago
user25730user25730
147110
asked 7 mins ago
user25730user25730
147110
asked 7 mins ago
user25730user25730
147110
147110
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
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
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-postgres-db-with-all-upper-case-name%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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-postgres-db-with-all-upper-case-name%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
