<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Brian,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Also, forgot this little tidbit that we (I?) discovered a while back, don’t even know if it’s a limitation anymore, but ESRI won’t allow much of anything edit-wise against the default database name (postgres) stating that it thinks this
is a System database. Have you tried using a different database name, something other than “postgres” for connecting, and to edit? I didn’t pursue things after discovering this other than trying to set up a database alias to postgres, but this didn’t work
the way I was expecting it to. It seems like a silly limit though, since we’ve been using the postgres database for our data for over a decade?? With no problems.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Anyway, some food for thought.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bobb<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Bob Basques <bob.basques@ci.stpaul.mn.us><br>
<b>Reply-To: </b>PostGIS Discussion <postgis-users@lists.osgeo.org><br>
<b>Date: </b>Wednesday, May 26, 2021 at 9:18 AM<br>
<b>To: </b>PostGIS Discussion <postgis-users@lists.osgeo.org><br>
<b>Subject: </b>Re: [postgis-users] Does ArcGIS 2.7 Pro work with PostgreSQL 13 / PostGIS 3.1<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
</div>
<table class="MsoNormalTable" border="1" cellpadding="0" style="margin-left:.5in;background:#E2F700;border:solid black 1.0pt">
<tbody>
<tr>
<td style="border:none;padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><strong><span style="font-family:"Calibri",sans-serif;color:#FF3333">Think Before You Click:
</span></strong><span style="color:black">This email originated <strong><span style="font-family:"Calibri",sans-serif">outside
</span></strong>our organization.</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in">Brian,<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Very interesting observations. I was actually wondering about this same type of scenario recently, A lot of the limits applied on the ESRI side end up being some sort of default setting that can be handled in
some form, the biggest piece is finding the setting(s), the next is having control over trying to mitigate them . . .<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">The newest version (400) of the AutoCAD extension for ESRI allows editing for example but with a bunch of predefined settings that need to be tweaked to make it work effectively. Not exactly the same as editing
in Postgres, but similar, so I’m sure there is a path to pursue here.<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Bobb<o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in"> <o:p></o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:1.0in"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Brian Wilson <brian@wildsong.biz><br>
<b>Reply-To: </b>PostGIS Discussion <postgis-users@lists.osgeo.org><br>
<b>Date: </b>Monday, May 24, 2021 at 11:32 PM<br>
<b>To: </b>PostGIS Discussion <postgis-users@lists.osgeo.org><br>
<b>Subject: </b>Re: [postgis-users] Does ArcGIS 2.7 Pro work with PostgreSQL 13 / PostGIS 3.1</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<table class="MsoNormalTable" border="1" cellpadding="0" style="margin-left:1.0in;background:#E2F700;border:solid black 1.0pt">
<tbody>
<tr>
<td style="border:none;padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><strong><span style="font-family:"Calibri",sans-serif;color:#FF3333">Think Before You Click:
</span></strong><span style="color:black">This email originated <strong><span style="font-family:"Calibri",sans-serif">outside
</span></strong>our organization.</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">When I've asked in the past, Esri people told me that PostGIS editing will not work. I always try things myself, regardless of what Esri people say. My answer is still NO, you cannot edit. I think the chances of
them enabling editing are pretty much non-existent. They want everyone to subscribe to an annual license for ArcGIS Enterprise and supporting PostGIS would dilute that effort so this is no surprise to me.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">I just installed ArcGIS Pro 2.8 this afternoon and tested it with a fresh install of PostGIS 3 / Postgresql 12 (running on Ubuntu Server installed from UbuntuGIS).
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">I am using a "personal" license so it's the "Advanced" version of Pro and I have the interop extension too.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">To get some data into PostGIS I loaded a polygon shapefile into QGIS and then used drag and dropto copy it into PostGIS, AMAZING and stunning to me how easy that was. Then I closed it and I started Pro 2.8, and
I was able to connect to the database and load in the PostGIS table as a feature class. It worked just fine. Then I tried to edit it and it said "This layer's workspace is readonly." I searched the properties for the layer and I searched Esri online help for
that string and found nothing. I am connected with the same credentials in both QGIS and Pro so the problem is in Pro.
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">Then I launched QGIS and edited a polygon there. I stumbled because I have not used it for editing but I managed to move a vertex. Then I refreshed the layer in Pro and the change immediately appeared.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">I don't have any way to test the Basic license of Pro. I disabled Interop to make sure it was not doing something behind the scenes to allow me to view PostGIS data, and that had no effect. With it turned off I
restarted Pro and the PostGIS layer loaded. AFAIK interop is just a very complicated ETL filter tool and does not do anything directly in the Pro GUI.
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in">Hope this helps -- Brian<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:1.0in"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>