ArcGIS not connecting to PostgreSQL db with all upper-case nameDirect 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

MAXDOP Settings for SQL Server 2014

Could the E-bike drivetrain wear down till needing replacement after 400 km?

Query about absorption line spectra

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

Visiting the UK as unmarried couple

How to color a curve

Longest common substring in linear time

On a tidally locked planet, would time be quantized?

Engineer refusing to file/disclose patents

How do ground effect vehicles perform turns?

Did arcade monitors have same pixel aspect ratio as TV sets?

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

Why is Arduino resetting while driving motors?

How do I repair my stair bannister?

Should I stop contributing to retirement accounts?

How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?

Is camera lens focus an exact point or a range?

Greatest common substring

Is there a word to describe the feeling of being transfixed out of horror?

THT: What is a squared annular “ring”?

API Access HTML/Javascript

Is it possible to use .desktop files to open local pdf files on specific pages with a browser?

How can "mimic phobia" be cured or prevented?

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



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?










share|improve this question
























  • 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
    3 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















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?










share|improve this question
























  • 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
    3 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













1












1








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?










share|improve this question
















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















share|improve this question













share|improve this question




share|improve this question








edited 3 hours ago









Vince

14.8k32749




14.8k32749










asked 4 hours ago









user25730user25730

152110




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
    3 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

















  • 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
    3 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
















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





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





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
3 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
3 hours ago




1




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






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





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










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






















    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


















    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















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    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



























      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

























        2












        2








        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













        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












        share|improve this answer



        share|improve this answer










        answered 14 mins ago









        VinceVince

        14.8k32749




        14.8k32749



























            draft saved

            draft discarded
















































            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.




            draft saved


            draft discarded














            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















            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







            Popular posts from this blog

            Disable / Remove link to Product Items in Cart Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?How can I limit products that can be bought / added to cart?Remove item from cartHide “Add to Cart” button if specific products are already in cart“Prettifying” the custom options in cart pageCreate link in cart sidebar to view all added items After limit reachedLink products together in checkout/cartHow to Get product from cart and add it againHide action-edit on cart page if simple productRemoving Cart items - ObserverRemove wishlist items when added to cart

            Helsingin valtaus Sisällysluettelo Taustaa | Yleistä sotatoimista | Osapuolet | Taistelut Helsingin ympäristössä | Punaisten antautumissuunnitelma | Taistelujen kulku Helsingissä | Valtauksen jälkeen | Tappiot | Muistaminen | Kirjallisuutta | Lähteet | Aiheesta muualla | NavigointivalikkoTeoksen verkkoversioTeoksen verkkoversioGoogle BooksSisällissota Helsingissä päättyi tasan 95 vuotta sittenSaksalaisten ylivoima jyräsi punaisen HelsinginSuomalaiset kuvaavat sotien jälkiä kaupungeissa – katso kuvat ja tarinat tutuilta kulmiltaHelsingin valtaus 90 vuotta sittenSaksalaiset valtasivat HelsinginHyökkäys HelsinkiinHelsingin valtaus 12.–13.4. 1918Saksalaiset käyttivät ihmiskilpiä Helsingin valtauksessa 1918Teoksen verkkoversioTeoksen verkkoversioSaksalaiset hyökkäävät Etelä-SuomeenTaistelut LeppävaarassaSotilaat ja taistelutLeppävaara 1918 huhtikuussa. KapinatarinaHelsingin taistelut 1918Saksalaisten voitonparaati HelsingissäHelsingin valtausta juhlittiinSaksalaisten Helsinki vuonna 1918Helsingin taistelussa kaatuneet valkokaartilaisetHelsinkiin haudatut taisteluissa kaatuneet punaiset12.4.1918 Helsingin valtauksessa saksalaiset apujoukot vapauttavat kaupunginVapaussodan muistomerkkejä Helsingissä ja pääkaupunkiseudullaCrescendo / Vuoden 1918 Kansalaissodan uhrien muistomerkkim

            Adjektiivitarina Tarinan tekeminen | Esimerkki: ennen | Esimerkki: jälkeen | Navigointivalikko