Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjHcj-0006TF-2J for pgadmin-hackers@arkaria.postgresql.org; Tue, 15 Jan 2019 05:50:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjHch-0000Fr-PG for pgadmin-hackers@arkaria.postgresql.org; Tue, 15 Jan 2019 05:50:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjHch-0000Fi-Js for pgadmin-hackers@lists.postgresql.org; Tue, 15 Jan 2019 05:50:51 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjHce-0004qT-HN for pgadmin-hackers@postgresql.org; Tue, 15 Jan 2019 05:50:51 +0000 Received: by mail-lf1-x132.google.com with SMTP id v5so1074295lfe.7 for ; Mon, 14 Jan 2019 21:50:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=s4RCT5jPPZ1EwHC7djTicrTbdIgRimqlffa8EuVLzyM=; b=lCuals92Zt1EzYeze2yV39mVrpo3n+MgVkRxqqS+lJkkRFsJMhLW792LryqqM0QiZW hFMyj75yKdLulpQFc38QwPV8YBGh58jjHDM+ML3kouhrwinuuD7s3hL5zb2ofj1g3Xb3 3JUIvgrfK+Dh44SNEEMEk8W9SbtmRH0zHgQ1HfU3jU7NArmv8O5Y4STkel2Oab0QK/bg 0lPiCYVLtiefrKUszuDNrpKK8ZtNCToAjSM1YeCxfXP5pCS/Uj5Bn0Q6I5LVhzzQdYsX qIeN8X60THODF6nu1Qw/XUPhR+SnIncqA9ZdPLqNd13xKblDlYjycMMU7RlwroANHQJI LfZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=s4RCT5jPPZ1EwHC7djTicrTbdIgRimqlffa8EuVLzyM=; b=bU0A+LA75J2WjeBCd63Jwx40M6Vbqwo6X5PKCYg5bhYtNWi9z902odjyCSK/54fT05 s9sBdbqn++ew88VrtTGDweYvZklSFMmObxQNwmUTsj3amDJpwHwTwkkyP4gfSsyuLzqn b+CH9M/GScIUGuPSm7KL+fH1MoeYTtDWT+bf94W2aT0VWvXQkpQE5NBSurOglcK4nO8u AzstI0WhabfQXvI9+LaQa+MHMO3mAcMso9AVXKtZyfc/FwV5X9tqQrKvULBnkLadcNBV Sqw7YWKclMmWutzArfTBdE4d9GO7XIbkEkDduTvDGzrNVOlZ1A3KqrAH21Mw3XrjH3nE tQ/A== X-Gm-Message-State: AJcUukcvq7sIsol9c+5H4m6j6DK9gC+paUUJoANwS+IM2J9aaSwviPKK uHnq8VRg8yyeH/QaH72xuYSzk7mQJftsGP4G4fA/XQ/KLGI= X-Google-Smtp-Source: ALg8bN5Ij/3M3H75C3RTEFtnuamDDDv50g0PEQSgr7A1Fc8ip2VMvALonH1R9E4mLeL/qkudt7akoggX+HhVKMvEsGs= X-Received: by 2002:a19:5394:: with SMTP id h20mr1499913lfl.75.1547531446680; Mon, 14 Jan 2019 21:50:46 -0800 (PST) MIME-Version: 1.0 From: Aditya Toshniwal Date: Tue, 15 Jan 2019 11:20:34 +0530 Message-ID: Subject: [pgAdmin4][RM3693] Message "Error saving properties Click on Detail" displayed if user create server group with same name To: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000028b845057f78be71" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000028b845057f78be71 Content-Type: multipart/alternative; boundary="00000000000028b841057f78be6f" --00000000000028b841057f78be6f Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached is the patch to fix back end exception which is common and mentioned in SQLAlchemy FAQ - https://docs.sqlalchemy.org/en/latest/faq/sessions.html#this-session-s-transaction-has-been-rolled-back-due-to-a-previous-exception-during-flush-or-similar The fix is as per the FAQ answer. Kindly review. -- Thanks and Regards, Aditya Toshniwal Software Engineer | EnterpriseDB Software Solutions | Pune "Don't Complain about Heat, Plant a tree" --00000000000028b841057f78be6f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Attached is the patch to fix = back end exception which is common and mentioned in SQLAlchemy FAQ -=C2=A0<= a href=3D"https://docs.sqlalchemy.org/en/latest/faq/sessions.html#this-sess= ion-s-transaction-has-been-rolled-back-due-to-a-previous-exception-during-f= lush-or-similar">https://docs.sqlalchemy.org/en/latest/faq/sessions.html#th= is-session-s-transaction-has-been-rolled-back-due-to-a-previous-exception-d= uring-flush-or-similar
The fix is as per the FAQ answer.

Kindly re= view.

--
Thanks and Regards,
Aditya Toshniwal
= Software Engineer |=C2=A0Enterp= riseDB Software Solutions |=C2=A0Pune
"Don't Complain abo= ut Heat, Plant a tree"
--00000000000028b841057f78be6f-- --00000000000028b845057f78be71 Content-Type: application/octet-stream; name="RM3693.patch" Content-Disposition: attachment; filename="RM3693.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_jqxc93710 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9fX2luaXRfXy5w eSBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9fX2luaXRfXy5weQppbmRleCA1 YjgwZWVmYy4uMjVhZGRmZDAgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVy X2dyb3Vwcy9fX2luaXRfXy5weQorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91 cHMvX19pbml0X18ucHkKQEAgLTE0NSw2ICsxNDUsNyBAQCBjbGFzcyBTZXJ2ZXJHcm91cFZpZXco Tm9kZVZpZXcpOgogICAgICAgICAgICAgICAgIGRiLnNlc3Npb24uZGVsZXRlKHNnKQogICAgICAg ICAgICAgICAgIGRiLnNlc3Npb24uY29tbWl0KCkKICAgICAgICAgICAgIGV4Y2VwdCBFeGNlcHRp b24gYXMgZToKKyAgICAgICAgICAgICAgICBkYi5zZXNzaW9uLnJvbGxiYWNrKCkKICAgICAgICAg ICAgICAgICByZXR1cm4gbWFrZV9qc29uX3Jlc3BvbnNlKAogICAgICAgICAgICAgICAgICAgICBz dGF0dXM9NDEwLCBzdWNjZXNzPTAsIGVycm9ybXNnPWUubWVzc2FnZQogICAgICAgICAgICAgICAg ICkKQEAgLTE3OCwxMCArMTc5LDEyIEBAIGNsYXNzIFNlcnZlckdyb3VwVmlldyhOb2RlVmlldyk6 CiAgICAgICAgICAgICAgICAgICAgIHNlcnZlcmdyb3VwLm5hbWUgPSBkYXRhW3UnbmFtZSddCiAg ICAgICAgICAgICAgICAgZGIuc2Vzc2lvbi5jb21taXQoKQogICAgICAgICAgICAgZXhjZXB0IGV4 Yy5JbnRlZ3JpdHlFcnJvcjoKKyAgICAgICAgICAgICAgICBkYi5zZXNzaW9uLnJvbGxiYWNrKCkK ICAgICAgICAgICAgICAgICByZXR1cm4gYmFkX3JlcXVlc3QoZ2V0dGV4dCgKICAgICAgICAgICAg ICAgICAgICAgIlRoZSBzcGVjaWZpZWQgc2VydmVyIGdyb3VwIGFscmVhZHkgZXhpc3RzLiIKICAg ICAgICAgICAgICAgICApKQogICAgICAgICAgICAgZXhjZXB0IEV4Y2VwdGlvbiBhcyBlOgorICAg ICAgICAgICAgICAgIGRiLnNlc3Npb24ucm9sbGJhY2soKQogICAgICAgICAgICAgICAgIHJldHVy biBtYWtlX2pzb25fcmVzcG9uc2UoCiAgICAgICAgICAgICAgICAgICAgIHN0YXR1cz00MTAsIHN1 Y2Nlc3M9MCwgZXJyb3Jtc2c9ZS5tZXNzYWdlCiAgICAgICAgICAgICAgICAgKQpAQCAtMjUxLDEx ICsyNTQsMTMgQEAgY2xhc3MgU2VydmVyR3JvdXBWaWV3KE5vZGVWaWV3KToKICAgICAgICAgICAg ICAgICAgICAgKQogICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgIGV4Y2VwdCBleGMuSW50 ZWdyaXR5RXJyb3I6CisgICAgICAgICAgICAgICAgZGIuc2Vzc2lvbi5yb2xsYmFjaygpCiAgICAg ICAgICAgICAgICAgcmV0dXJuIGJhZF9yZXF1ZXN0KGdldHRleHQoCiAgICAgICAgICAgICAgICAg ICAgICJUaGUgc3BlY2lmaWVkIHNlcnZlciBncm91cCBhbHJlYWR5IGV4aXN0cy4iCiAgICAgICAg ICAgICAgICAgKSkKIAogICAgICAgICAgICAgZXhjZXB0IEV4Y2VwdGlvbiBhcyBlOgorICAgICAg ICAgICAgICAgIGRiLnNlc3Npb24ucm9sbGJhY2soKQogICAgICAgICAgICAgICAgIHJldHVybiBt YWtlX2pzb25fcmVzcG9uc2UoCiAgICAgICAgICAgICAgICAgICAgIHN0YXR1cz00MTAsCiAgICAg ICAgICAgICAgICAgICAgIHN1Y2Nlc3M9MCwK --00000000000028b845057f78be71--