codekingpro/portable-devtools
114k
1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6 <head>
7 <meta charset="utf-8" />
8 <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10 <title>Version 5.7 — pgAdmin 4 8.6 documentation</title>
11 <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12 <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13
14 <script src="_static/documentation_options.js?v=d4c83366"></script>
15 <script src="_static/doctools.js?v=9a2dae69"></script>
16 <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17
18 <script src="_static/sidebar.js"></script>
19
20 <link rel="index" title="Index" href="genindex.html" />
21 <link rel="search" title="Search" href="search.html" />
22 <link rel="next" title="Version 5.6" href="release_notes_5_6.html" />
23 <link rel="prev" title="Version 6.0" href="release_notes_6_0.html" />
24 </head><body>
25 <div class="related" role="navigation" aria-label="related navigation">
26 <h3>Navigation</h3>
27 <ul>
28 <li class="right" style="margin-right: 10px">
29 <a href="genindex.html" title="General Index"
30 accesskey="I">index</a></li>
31 <li class="right" >
32 <a href="release_notes_5_6.html" title="Version 5.6"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="release_notes_6_0.html" title="Version 6.0"
36 accesskey="P">previous</a> |</li>
37 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
38 <li class="nav-item nav-item-1"><a href="release_notes.html" accesskey="U">Release Notes</a> »</li>
39 <li class="nav-item nav-item-this"><a href="">Version 5.7</a></li>
40 </ul>
41 </div>
42
43 <div class="document">
44 <div class="documentwrapper">
45 <div class="bodywrapper">
46 <div class="body" role="main">
47
48 <section id="version-5-7">
49<h1>Version 5.7<a class="headerlink" href="#version-5-7" title="Link to this heading">¶</a></h1>
50<p>Release date: 2021-09-09</p>
51<p>This release contains a number of bug fixes and new features since the release of pgAdmin4 5.6.</p>
52<section id="new-features">
53<h2>New features<a class="headerlink" href="#new-features" title="Link to this heading">¶</a></h2>
54<div class="line-block">
55<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/2538">Issue #2538</a> - Added support for the truncate table with restart identity.</div>
56<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/4264">Issue #4264</a> - Make code folding case insensitive in the code mirror.</div>
57<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/4629">Issue #4629</a> - Added database and server information on the Maintenance process watcher dialog.</div>
58<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6495">Issue #6495</a> - Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool.</div>
59<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6625">Issue #6625</a> - Make closing tabs to be smarter by focusing on the appropriate tab when the user closed a tab.</div>
60<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6691">Issue #6691</a> - Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode.</div>
61</div>
62</section>
63<section id="housekeeping">
64<h2>Housekeeping<a class="headerlink" href="#housekeeping" title="Link to this heading">¶</a></h2>
65</section>
66<section id="bug-fixes">
67<h2>Bug fixes<a class="headerlink" href="#bug-fixes" title="Link to this heading">¶</a></h2>
68<div class="line-block">
69<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/4567">Issue #4567</a> - Fixed an issue where privileges were revoked using SQL query on objects like tables that do not correctly show in SQL tab.</div>
70<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/4815">Issue #4815</a> - Fixed an issue where the user can not paste the updated table header in safari 12 and 13 browsers.</div>
71<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/5849">Issue #5849</a> - Ensure that trigger function SQL should have ‘create or replace function’ instead of ‘create function’ only.</div>
72<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6419">Issue #6419</a> - Fixed blank screen issue on windows and also made changes to use NWjs manifest for remembering window size.</div>
73<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6531">Issue #6531</a> - Fixed the export image issue where relation lines are over the nodes.</div>
74<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6544">Issue #6544</a> - Fixed width limitation issue in PSQL tool window.</div>
75<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6564">Issue #6564</a> - Fixed an issue where columns with sequences get altered unnecessarily with a schema diff tool.</div>
76<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6570">Issue #6570</a> - Ensure that the lock panel should not be blocked for larger records.</div>
77<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6572">Issue #6572</a> - Partially fixes the data output panel display issue.</div>
78<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6620">Issue #6620</a> - Fixed an issue where whitespace in function bodies was not applied while generating the script using Schema Diff.</div>
79<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6627">Issue #6627</a> - Introduced OAUTH2_SCOPE variable for the Oauth2 scope configuration.</div>
80<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6641">Issue #6641</a> - Enables pgAdmin to retrieve user permissions in case of nested roles which helps to terminate the session for AWS RDS.</div>
81<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6663">Issue #6663</a> - Fixed no attribute ‘_asdict’ error when connecting the database server.</div>
82<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6668">Issue #6668</a> - Fixed errors related to HTML tags shown in the error message for JSON editor.</div>
83<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6671">Issue #6671</a> - Fixed UnboundLocalError where local variable ‘user_id’ referenced before assignment.</div>
84<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6682">Issue #6682</a> - Renamed ‘Auto rollback?’ to ‘Auto rollback on error?’.</div>
85<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6684">Issue #6684</a> - Fixed the JSON editor issue of hiding the first record.</div>
86<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6685">Issue #6685</a> - Ensure that deleting a database should not automatically connect to the next database.</div>
87<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6704">Issue #6704</a> - Ensure that pgAdmin should not fail at login due to a special character in the hostname.</div>
88<div class="line"><a class="reference external" href="https://redmine.postgresql.org/issues/6710">Issue #6710</a> - Fixed an issue where multiple query tool tabs getting closed for the single close event.</div>
89</div>
90</section>
91</section>
92
93
94 <div class="clearer"></div>
95 </div>
96 </div>
97 </div>
98 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
99 <div class="sphinxsidebarwrapper">
100 <div>
101 <h3><a href="index.html">Table of Contents</a></h3>
102 <ul>
103<li><a class="reference internal" href="#">Version 5.7</a><ul>
104<li><a class="reference internal" href="#new-features">New features</a></li>
105<li><a class="reference internal" href="#housekeeping">Housekeeping</a></li>
106<li><a class="reference internal" href="#bug-fixes">Bug fixes</a></li>
107</ul>
108</li>
109</ul>
110
111 </div>
112<h3><a href="index.html">Table of Contents</a></h3>
113<ul class="current">
114<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
115<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
116<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
117<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
118<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
119<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
120<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
121<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
122<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
123<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
124<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
125<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
126<li class="toctree-l1 current"><a class="reference internal" href="release_notes.html">Release Notes</a><ul class="current">
127<li class="toctree-l2"><a class="reference internal" href="release_notes_8_6.html">Version 8.6</a></li>
128<li class="toctree-l2"><a class="reference internal" href="release_notes_8_5.html">Version 8.5</a></li>
129<li class="toctree-l2"><a class="reference internal" href="release_notes_8_4.html">Version 8.4</a></li>
130<li class="toctree-l2"><a class="reference internal" href="release_notes_8_3.html">Version 8.3</a></li>
131<li class="toctree-l2"><a class="reference internal" href="release_notes_8_2.html">Version 8.2</a></li>
132<li class="toctree-l2"><a class="reference internal" href="release_notes_8_1.html">Version 8.1</a></li>
133<li class="toctree-l2"><a class="reference internal" href="release_notes_8_0.html">Version 8.0</a></li>
134<li class="toctree-l2"><a class="reference internal" href="release_notes_7_8.html">Version 7.8</a></li>
135<li class="toctree-l2"><a class="reference internal" href="release_notes_7_7.html">Version 7.7</a></li>
136<li class="toctree-l2"><a class="reference internal" href="release_notes_7_6.html">Version 7.6</a></li>
137<li class="toctree-l2"><a class="reference internal" href="release_notes_7_5.html">Version 7.5</a></li>
138<li class="toctree-l2"><a class="reference internal" href="release_notes_7_4.html">Version 7.4</a></li>
139<li class="toctree-l2"><a class="reference internal" href="release_notes_7_3.html">Version 7.3</a></li>
140<li class="toctree-l2"><a class="reference internal" href="release_notes_7_2.html">Version 7.2</a></li>
141<li class="toctree-l2"><a class="reference internal" href="release_notes_7_1.html">Version 7.1</a></li>
142<li class="toctree-l2"><a class="reference internal" href="release_notes_7_0.html">Version 7.0</a></li>
143<li class="toctree-l2"><a class="reference internal" href="release_notes_6_21.html">Version 6.21</a></li>
144<li class="toctree-l2"><a class="reference internal" href="release_notes_6_20.html">Version 6.20</a></li>
145<li class="toctree-l2"><a class="reference internal" href="release_notes_6_19.html">Version 6.19</a></li>
146<li class="toctree-l2"><a class="reference internal" href="release_notes_6_18.html">Version 6.18</a></li>
147<li class="toctree-l2"><a class="reference internal" href="release_notes_6_17.html">Version 6.17</a></li>
148<li class="toctree-l2"><a class="reference internal" href="release_notes_6_16.html">Version 6.16</a></li>
149<li class="toctree-l2"><a class="reference internal" href="release_notes_6_15.html">Version 6.15</a></li>
150<li class="toctree-l2"><a class="reference internal" href="release_notes_6_14.html">Version 6.14</a></li>
151<li class="toctree-l2"><a class="reference internal" href="release_notes_6_13.html">Version 6.13</a></li>
152<li class="toctree-l2"><a class="reference internal" href="release_notes_6_12.html">Version 6.12</a></li>
153<li class="toctree-l2"><a class="reference internal" href="release_notes_6_11.html">Version 6.11</a></li>
154<li class="toctree-l2"><a class="reference internal" href="release_notes_6_10.html">Version 6.10</a></li>
155<li class="toctree-l2"><a class="reference internal" href="release_notes_6_9.html">Version 6.9</a></li>
156<li class="toctree-l2"><a class="reference internal" href="release_notes_6_8.html">Version 6.8</a></li>
157<li class="toctree-l2"><a class="reference internal" href="release_notes_6_7.html">Version 6.7</a></li>
158<li class="toctree-l2"><a class="reference internal" href="release_notes_6_6.html">Version 6.6</a></li>
159<li class="toctree-l2"><a class="reference internal" href="release_notes_6_5.html">Version 6.5</a></li>
160<li class="toctree-l2"><a class="reference internal" href="release_notes_6_4.html">Version 6.4</a></li>
161<li class="toctree-l2"><a class="reference internal" href="release_notes_6_3.html">Version 6.3</a></li>
162<li class="toctree-l2"><a class="reference internal" href="release_notes_6_2.html">Version 6.2</a></li>
163<li class="toctree-l2"><a class="reference internal" href="release_notes_6_1.html">Version 6.1</a></li>
164<li class="toctree-l2"><a class="reference internal" href="release_notes_6_0.html">Version 6.0</a></li>
165<li class="toctree-l2 current"><a class="current reference internal" href="#">Version 5.7</a></li>
166<li class="toctree-l2"><a class="reference internal" href="release_notes_5_6.html">Version 5.6</a></li>
167<li class="toctree-l2"><a class="reference internal" href="release_notes_5_5.html">Version 5.5</a></li>
168<li class="toctree-l2"><a class="reference internal" href="release_notes_5_4.html">Version 5.4</a></li>
169<li class="toctree-l2"><a class="reference internal" href="release_notes_5_3.html">Version 5.3</a></li>
170<li class="toctree-l2"><a class="reference internal" href="release_notes_5_2.html">Version 5.2</a></li>
171<li class="toctree-l2"><a class="reference internal" href="release_notes_5_1.html">Version 5.1</a></li>
172<li class="toctree-l2"><a class="reference internal" href="release_notes_5_0.html">Version 5.0</a></li>
173<li class="toctree-l2"><a class="reference internal" href="release_notes_4_30.html">Version 4.30</a></li>
174<li class="toctree-l2"><a class="reference internal" href="release_notes_4_29.html">Version 4.29</a></li>
175<li class="toctree-l2"><a class="reference internal" href="release_notes_4_28.html">Version 4.28</a></li>
176<li class="toctree-l2"><a class="reference internal" href="release_notes_4_27.html">Version 4.27</a></li>
177<li class="toctree-l2"><a class="reference internal" href="release_notes_4_26.html">Version 4.26</a></li>
178<li class="toctree-l2"><a class="reference internal" href="release_notes_4_25.html">Version 4.25</a></li>
179<li class="toctree-l2"><a class="reference internal" href="release_notes_4_24.html">Version 4.24</a></li>
180<li class="toctree-l2"><a class="reference internal" href="release_notes_4_23.html">Version 4.23</a></li>
181<li class="toctree-l2"><a class="reference internal" href="release_notes_4_22.html">Version 4.22</a></li>
182<li class="toctree-l2"><a class="reference internal" href="release_notes_4_21.html">Version 4.21</a></li>
183<li class="toctree-l2"><a class="reference internal" href="release_notes_4_20.html">Version 4.20</a></li>
184<li class="toctree-l2"><a class="reference internal" href="release_notes_4_19.html">Version 4.19</a></li>
185<li class="toctree-l2"><a class="reference internal" href="release_notes_4_18.html">Version 4.18</a></li>
186<li class="toctree-l2"><a class="reference internal" href="release_notes_4_17.html">Version 4.17</a></li>
187<li class="toctree-l2"><a class="reference internal" href="release_notes_4_16.html">Version 4.16</a></li>
188<li class="toctree-l2"><a class="reference internal" href="release_notes_4_15.html">Version 4.15</a></li>
189<li class="toctree-l2"><a class="reference internal" href="release_notes_4_14.html">Version 4.14</a></li>
190<li class="toctree-l2"><a class="reference internal" href="release_notes_4_13.html">Version 4.13</a></li>
191<li class="toctree-l2"><a class="reference internal" href="release_notes_4_12.html">Version 4.12</a></li>
192<li class="toctree-l2"><a class="reference internal" href="release_notes_4_11.html">Version 4.11</a></li>
193<li class="toctree-l2"><a class="reference internal" href="release_notes_4_10.html">Version 4.10</a></li>
194<li class="toctree-l2"><a class="reference internal" href="release_notes_4_9.html">Version 4.9</a></li>
195<li class="toctree-l2"><a class="reference internal" href="release_notes_4_8.html">Version 4.8</a></li>
196<li class="toctree-l2"><a class="reference internal" href="release_notes_4_7.html">Version 4.7</a></li>
197<li class="toctree-l2"><a class="reference internal" href="release_notes_4_6.html">Version 4.6</a></li>
198<li class="toctree-l2"><a class="reference internal" href="release_notes_4_5.html">Version 4.5</a></li>
199<li class="toctree-l2"><a class="reference internal" href="release_notes_4_4.html">Version 4.4</a></li>
200<li class="toctree-l2"><a class="reference internal" href="release_notes_4_3.html">Version 4.3</a></li>
201<li class="toctree-l2"><a class="reference internal" href="release_notes_4_2.html">Version 4.2</a></li>
202<li class="toctree-l2"><a class="reference internal" href="release_notes_4_1.html">Version 4.1</a></li>
203<li class="toctree-l2"><a class="reference internal" href="release_notes_4_0.html">Version 4.0</a></li>
204<li class="toctree-l2"><a class="reference internal" href="release_notes_3_6.html">Version 3.6</a></li>
205<li class="toctree-l2"><a class="reference internal" href="release_notes_3_5.html">Version 3.5</a></li>
206<li class="toctree-l2"><a class="reference internal" href="release_notes_3_4.html">Version 3.4</a></li>
207<li class="toctree-l2"><a class="reference internal" href="release_notes_3_3.html">Version 3.3</a></li>
208<li class="toctree-l2"><a class="reference internal" href="release_notes_3_2.html">Version 3.2</a></li>
209<li class="toctree-l2"><a class="reference internal" href="release_notes_3_1.html">Version 3.1</a></li>
210<li class="toctree-l2"><a class="reference internal" href="release_notes_3_0.html">Version 3.0</a></li>
211<li class="toctree-l2"><a class="reference internal" href="release_notes_2_1.html">Version 2.1</a></li>
212<li class="toctree-l2"><a class="reference internal" href="release_notes_2_0.html">Version 2.0</a></li>
213<li class="toctree-l2"><a class="reference internal" href="release_notes_1_6.html">Version 1.6</a></li>
214<li class="toctree-l2"><a class="reference internal" href="release_notes_1_5.html">Version 1.5</a></li>
215<li class="toctree-l2"><a class="reference internal" href="release_notes_1_4.html">Version 1.4</a></li>
216<li class="toctree-l2"><a class="reference internal" href="release_notes_1_3.html">Version 1.3</a></li>
217<li class="toctree-l2"><a class="reference internal" href="release_notes_1_2.html">Version 1.2</a></li>
218<li class="toctree-l2"><a class="reference internal" href="release_notes_1_1.html">Version 1.1</a></li>
219<li class="toctree-l2"><a class="reference internal" href="release_notes_1_0.html">Version 1.0</a></li>
220</ul>
221</li>
222<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
223</ul>
224
225<search id="searchbox" style="display: none" role="search">
226 <h3 id="searchlabel">Quick search</h3>
227 <div class="searchformwrapper">
228 <form class="search" action="search.html" method="get">
229 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
230 <input type="submit" value="Go" />
231 </form>
232 </div>
233</search>
234<script>document.getElementById('searchbox').style.display = "block"</script>
235 </div>
236<div id="sidebarbutton" title="Collapse sidebar">
237<span>«</span>
238</div>
239
240 </div>
241 <div class="clearer"></div>
242 </div>
243 <div class="related" role="navigation" aria-label="related navigation">
244 <h3>Navigation</h3>
245 <ul>
246 <li class="right" style="margin-right: 10px">
247 <a href="genindex.html" title="General Index"
248 >index</a></li>
249 <li class="right" >
250 <a href="release_notes_5_6.html" title="Version 5.6"
251 >next</a> |</li>
252 <li class="right" >
253 <a href="release_notes_6_0.html" title="Version 6.0"
254 >previous</a> |</li>
255 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
256 <li class="nav-item nav-item-1"><a href="release_notes.html" >Release Notes</a> »</li>
257 <li class="nav-item nav-item-this"><a href="">Version 5.7</a></li>
258 </ul>
259 </div>
260 <div class="footer" role="contentinfo">
261 <div class="related" role="navigation" aria-label="related navigation">
262 <ul>
263 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
264 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
265 <li class="right" ><a href="release_notes_5_6.html" title="Version 5.6" accesskey="N">next</a> |</li>
266 <li class="right" ><a href="release_notes_6_0.html" title="Version 6.0" accesskey="P">previous</a> |</li>
267 </ul>
268 </div>
269 </div>
270 </body>
271</html>