http://postgres.cz/index.php?action=history&feed=atom&title=Pavel_St%C4%9Bhule_patche 2026-04-07T20:57:49Z Historie editací této stránky MediaWiki 1.43.3 http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=1238&oldid=prev 2025-03-04T05:40:12Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 4. 3. 2025, 05:40</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l129">Řádek 129:</td> <td colspan="2" class="diff-lineno">Řádek 129:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 17 (Release date: 2024-09-26)===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 17 (Release date: 2024-09-26)===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a5cf808be55bcc68c3917c380f95122436af1be1 možnost čtení filtrů ze souboru]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a5cf808be55bcc68c3917c380f95122436af1be1 možnost čtení filtrů ze souboru]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">===PostgreSQL 18 ===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=246dedc5d028800b393920184e5e6319c6805253 možnost použít standardní syntax pro pojmenované parametry pro parametry kurzoru]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Neakceptované patche==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Neakceptované patche==</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1215:rev-1238:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=1215&oldid=prev 2025-02-08T20:21:02Z

<p><span class="autocomment">PostgreSQL 9.5 (Release date: 2016-01-07)</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 8. 2. 2025, 20:21</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l84">Řádek 84:</td> <td colspan="2" class="diff-lineno">Řádek 84:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=13dbc7a824b3f905904cab51840d37f31a07a9ef získání pozice prvku v poli]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=13dbc7a824b3f905904cab51840d37f31a07a9ef získání pozice prvku v poli]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [http://git.postgresql.org/pg/commitdiff/a4847fc3ef139ba9a8ffebb6ffa06ee72078ffa2 plpgsql příkaz ASSERT]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [http://git.postgresql.org/pg/commitdiff/a4847fc3ef139ba9a8ffebb6ffa06ee72078ffa2 plpgsql příkaz ASSERT]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [https://github.com/postgres/postgres/commit/865f14a2d31af23a05bbf2df04c274629c5d5c4d možnost používat standardní syntax pro pojmenované parametry]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 9.6 (Release date: 2016-09-29)===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 9.6 (Release date: 2016-09-29)===</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1207:rev-1215:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=1207&oldid=prev 2025-01-23T06:16:29Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 23. 1. 2025, 06:16</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l125">Řádek 125:</td> <td colspan="2" class="diff-lineno">Řádek 125:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53ef6c40f1e7ff6c9ad9a221cd9999dd147ec3a2 rozšíření plpgsql dbg API]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53ef6c40f1e7ff6c9ad9a221cd9999dd147ec3a2 rozšíření plpgsql dbg API]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 16===</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 16 <ins style="font-weight: bold; text-decoration: none;">(Release date: 2023-09-14)</ins>===</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 17===</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 17 <ins style="font-weight: bold; text-decoration: none;">(Release date: 2024-09-26)</ins>===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a5cf808be55bcc68c3917c380f95122436af1be1 možnost čtení filtrů ze souboru]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a5cf808be55bcc68c3917c380f95122436af1be1 možnost čtení filtrů ze souboru]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-966:rev-1207:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=966&oldid=prev 2023-11-29T15:54:53Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 29. 11. 2023, 15:54</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l124">Řádek 124:</td> <td colspan="2" class="diff-lineno">Řádek 124:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 15 (Release date: 2022-10-13)===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 15 (Release date: 2022-10-13)===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53ef6c40f1e7ff6c9ad9a221cd9999dd147ec3a2 rozšíření plpgsql dbg API]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53ef6c40f1e7ff6c9ad9a221cd9999dd147ec3a2 rozšíření plpgsql dbg API]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">===PostgreSQL 16===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">===PostgreSQL 17===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a5cf808be55bcc68c3917c380f95122436af1be1 možnost čtení filtrů ze souboru]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Neakceptované patche==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Neakceptované patche==</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-950:rev-966:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=950&oldid=prev 2023-10-14T04:40:20Z

<p><span class="autocomment">PostgreSQL 15 (Release date: 2022-10-??)</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 14. 10. 2023, 04:40</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l122">Řádek 122:</td> <td colspan="2" class="diff-lineno">Řádek 122:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f37fec837ce8bf7af408ba66d32099e5a0182402 funkce unistr]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f37fec837ce8bf7af408ba66d32099e5a0182402 funkce unistr]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 15 (Release date: 2022-10-<del style="font-weight: bold; text-decoration: none;">??</del>)===</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 15 (Release date: 2022-10-<ins style="font-weight: bold; text-decoration: none;">13</ins>)===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53ef6c40f1e7ff6c9ad9a221cd9999dd147ec3a2 rozšíření plpgsql dbg API]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53ef6c40f1e7ff6c9ad9a221cd9999dd147ec3a2 rozšíření plpgsql dbg API]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-731:rev-950:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=731&oldid=prev 2022-04-01T05:00:27Z

<p><span class="autocomment">PostgreSQL 14 (Release date: 2021-10-??)</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 1. 4. 2022, 05:00</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l116">Řádek 116:</td> <td colspan="2" class="diff-lineno">Řádek 116:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24e2885ee304cb6a94fdfc25a1a108344ed9f4f7 další třída polymorfních typů s vynuceným přetypováním anycompatible]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24e2885ee304cb6a94fdfc25a1a108344ed9f4f7 další třída polymorfních typů s vynuceným přetypováním anycompatible]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 14 (Release date: 2021-10-<del style="font-weight: bold; text-decoration: none;">??</del>)===</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===PostgreSQL 14 (Release date: 2021-10-<ins style="font-weight: bold; text-decoration: none;">30</ins>)===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=66f163068030b5c5fe792a0daee27822dac43791 funkce string_to_table]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=66f163068030b5c5fe792a0daee27822dac43791 funkce string_to_table]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f0e4ec74e452f55922b52f50da4ba4834771a268 fix memory leak příkazu CALL]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f0e4ec74e452f55922b52f50da4ba4834771a268 fix memory leak příkazu CALL]</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-730:rev-731:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=730&oldid=prev 2022-04-01T04:53:26Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 1. 4. 2022, 04:53</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l121">Řádek 121:</td> <td colspan="2" class="diff-lineno">Řádek 121:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ee895a655ce4341546facd6f23e3e8f2931b96bf zpristupneni plan cache pro prikaz CALL]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ee895a655ce4341546facd6f23e3e8f2931b96bf zpristupneni plan cache pro prikaz CALL]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f37fec837ce8bf7af408ba66d32099e5a0182402 funkce unistr]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f37fec837ce8bf7af408ba66d32099e5a0182402 funkce unistr]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">===PostgreSQL 15 (Release date: 2022-10-??)===</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53ef6c40f1e7ff6c9ad9a221cd9999dd147ec3a2 rozšíření plpgsql dbg API]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Neakceptované patche==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Neakceptované patche==</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-430:rev-730:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Pavel_St%C4%9Bhule_patche&diff=430&oldid=prev 2021-03-29T10:24:55Z

<p></p> <p><b>Nová stránka</b></p><div>==Seznam patchů==<br /> PostgreSQL je výsledkem práce týmu vývojářů, nikoliv jednotlivců. Implementace nové funkce je zřídka výsledkem práce pouze jednoho člověka. I když, neocenitelné zásluhy má hlavně Tom Lane, který finalizuje většinu kódu před vlastní integrací do jádra PostgreSQL. Dále nesmím zapomenout na Nikolaje Samochvalova, který převzal a přepracoval moji prototypovou implementaci SQL/XML a dovedl ji do stavu, kdy ji bylo možné integrovat do PostgreSQL. <br /> <br /> ===PostgreSQL 7.4 (Release date: 2003-11-17)===<br /> *český překlad FAQ,<br /> *uložení informace o použitém kódování do dumpu databáze a automatické dekódování při načtení dumpu,<br /> ===PostgreSQL 8.1 (Release date: 2005-11-08)===<br /> *volitelné označení PL/pgSQL bloku návěstím, <br /> *implementace funkcí GREATEST a LEAST,<br /> *příkaz CONTINUE v PL/pgSQL,<br /> *rozšíření operátoru BETWEEN o atribut SYMMETRIC,<br /> *podpora zobrazení výrazů v příkazu RAISE,<br /> *podpora klauzule INTO v příkazu EXECUTE,<br /> *přístup ke kódu a popisu výjimky v PL/pgSQL - proměnné SQLERRM a SQLSTATE,<br /> ===PostgreSQL 8.2 (Release date: 2006-12-05)===<br /> *Podpora OUT parametrů typu pole v PL/Perl,<br /> *možnost použití seznamu skalárních proměnných v příkazu FOR v PL/pgSQL,<br /> *Implementace operátoru IS NOT DISTINCT FROM,<br /> ===PostgreSQL 8.3 (Release date: 2008-02-04)===<br /> *podpora SCROLLABLE kurzorů v PL/pgSQL, příkaz MOVE v PL/pgSQL,<br /> *prototyp SQL/XML,<br /> *příkaz RETURN QUERY,<br /> *modul pro zajištění kompatibility s TSearch2,<br /> ===PostgreSQL 8.4 (Release date: 2009-07-01)===<br /> *příkaz RETURN QUERY EXECUTE,<br /> *rozšíření příkazu FOR pro kurzor,<br /> *klauzule USING v příkazu EXECUTE,<br /> *možnost nastavení atributů výjimky v příkazu RAISE, možnost určení kódu a názvu výjimky,<br /> *příkaz CASE v PL/pgSQL,<br /> *funkce array_fill a generate_subscripts,<br /> *podpora variadických funkcí a variadických parametrů,<br /> *podpora tabulkových funkcí dle ansi sql - příkaz CREATE FUNCTIONS RETURNS TABLE,<br /> *defaultní parametry PL funkcí.<br /> ===PostgreSQL 9.0 (Release date: 2010-09-20)===<br /> *[http://archives.postgresql.org/pgsql-committers/2009-07/msg00199.php revize kódu PL/pgSQL - odstranění duplicitního kódu],<br /> *[http://archives.postgresql.org/pgsql-committers/2009-08/msg00068.php fix příkazu RETURN QUERY (ve spolupráci s Tomem Lanem)],<br /> *[http://archives.postgresql.org/pgsql-committers/2009-09/msg00235.php sjednocení syntaxe scrollable kurzorů v PL/pgSQL],<br /> *[http://archives.postgresql.org/pgsql-committers/2009-10/msg00035.php mixed and named notation].<br /> *[http://archives.postgresql.org/pgsql-committers/2010-01/msg00287.php klauzule USING pro OPEN cursor FOR EXECUTE]<br /> *[http://archives.postgresql.org/pgsql-committers/2010-01/msg00432.php escape expanze proměnných v psql]<br /> *[http://archives.postgresql.org/pgsql-committers/2010-01/msg00486.php agregační funkce string_agg]<br /> <br /> ===PostgreSQL 9.1 (Release date: 2011-09-12)===<br /> * [http://archives.postgresql.org/pgsql-committers/2010-08/msg00119.php refaktoring funkcí array_to_string a string_to_array]<br /> * [http://archives.postgresql.org/pgsql-committers/2010-08/msg00120.php fix - odstranění omezení deseti parametrů ve funkci xslt_process]<br /> * [http://archives.postgresql.org/pgsql-committers/2010-08/msg00144.php přesun na specifikovonou řádku kódu uložené procedury v externím editoru]<br /> * [http://archives.postgresql.org/pgsql-committers/2010-08/msg00174.php zobrazení zdrojového kódu uložených procedur v psql]<br /> * [http://archives.postgresql.org/pgsql-committers/2010-08/msg00284.php doplňkové funkce pro operace s řetězci - left, right, reverese, concat, concat_ws]<br /> * [http://archives.postgresql.org/pgsql-committers/2010-10/msg00044.php významná redukce spotřeby paměti pro načtení českých slovníků]<br /> * [http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=b48b9cb3a46d80401b122fd10780e8c623983a26 autocomplete psql proměnných]<br /> * [http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=750487077802861a2accd94164166747ec311fa4 funkce formát - variace na sprintf]<br /> * [http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=6e02755b22ea62775c906d29b87b55b38ab70bd2 příkaz FOREACH - iterace nad polem v plpgsql]<br /> *[https://github.com/postgres/postgres/commit/b6e06942c6b880b79097049757a8d140cd4316c0#diff-503ba641cac30d169aa3c2b09015fc39 psql příkaz pro zobrazení funkce \sf]<br /> *[https://github.com/postgres/postgres/commit/568e709372abad30075c299be28956b5922219b4#diff-503ba641cac30d169aa3c2b09015fc39 možnost skočit na ntý řádek příkazu \ef]<br /> <br /> ===PostgreSQL 9.2 (Release date: 2012-09-10)===<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3d4890c0c5d27dfdf7d1a8816d7bdcdba3c39d21 přístup k datům výjimky z příkazu GET STACKED DIAGNOSTICS]<br /> * [http://archives.postgresql.org/pgsql-committers/2011-09/msg00294.php použití cache pro opakovaný přístup k prvkům pole]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b8a91d9d1c7ec75aaecf13df687ec7b5b0ed35a6 podmíněný ALTER TABLE IF EXISTS ...]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4c6cedd1b014abf2046886a9a92e10e18f0d658e použití signatury funkce ve výpisu kontextu místo jména]<br /> <br /> ===PostgreSQL 9.3 (Release date: 2013-09-09) ===<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7ae1815961c635fd1a6fe72acb89fdef741a45a8 GET DIAGNOSTICS rc=ROW_COUNT pro COPY]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=760f3c043ad4ee622b596d005ec31bb5e0322c4a oprava variadických &quot;any&quot; funkcí pro nevariadický způsob volání]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=991f3e5ab3f8196d18d5b313c81a5f744f3baaea základ pro &quot;strukturované&quot; výjimky]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d2d153fdb08053d655bd0fef14187eed6a674193 příkaz \gset]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=73e7025bd8eed941a068f0a7a71e02dca8d38d1c podpora zarovnávání ve funkci format]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c21bb48d6fc1827e117e2667e0a5d9d96d984f46 přístup k rozšiřujícím položkám vyjímky z PL/pgSQL]<br /> <br /> ===PostgreSQL 9.4 (Release date: 2014-12-18)===<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d26888bc4d1e539a82f21382b0000fe5bbf889d9 globální kontroly variadických funkcí (dokončení implementace)]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=831283256796d1c20858862b568d73e505eb4a84 GET DIAGNOSTICS stack=PG_CONTEXT - čtení stacku]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c50b7c09d852b6dc292bf24c72a0ffcac6cb2cab funkce pro snažší práci s LO z prostředí SQL - konverze z bytea z/do LO]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f901bb50e33ad95593bb68f7b3b55eb2e47607dc datumový a časový konstruktor make_time a make_date]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b152c6cd0de1827ba58756e24e18110cf902182a úplný konzistentní fully fault tolerant DROP IF EXISTS]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=9067310cc5dd590e36c2c3219dbf3961d7c9f8cb vynucení DROP IF EXISTS v pg_dump(all) přepínačem --if-exists]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=84df54b22e8035addc7108abd9ff6995e8c49264 make_timestamp, make_timestamptz, make_interval]<br /> <br /> ===PostgreSQL 9.5 (Release date: 2016-01-07)===<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5b214c5dd1de37764797b3fb9164af3c885a7b86 při čtení SQL skriptu zobrazí pouze chybné dotazy]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e15c4ab5fb0de2cab393ed4be2136e1832746412 autocomplete pro obsah vestavenych psql promennych]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=07c8651dd91d5aea38bee268acb582674ca4b5ea nápověda k psql proměnným]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a2dabf0e1dda93c860b10bff7b73617e7b090108 možnost používat UTF rámečky se zdvojenou čarou]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=13dbc7a824b3f905904cab51840d37f31a07a9ef získání pozice prvku v poli]<br /> * [http://git.postgresql.org/pg/commitdiff/a4847fc3ef139ba9a8ffebb6ffa06ee72078ffa2 plpgsql příkaz ASSERT]<br /> <br /> ===PostgreSQL 9.6 (Release date: 2016-09-29)===<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0426f349effb6bde2061f3398a71db7180c97dd9 oprava chování zobrazení kontextu příkazu RAISE EXCEPTION]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3ae16798f0f9d2d941e50062b579c28c9b946c9e autocomplete pro enum a pro logické konfigurační proměnné]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d02426029b133ee2bbe492a038642359bce3c527 důslednější kontrola parametrů příkazu pg_dump a pg_restore]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d5563d7df94488bf0ab52ac0678e8a07e5b8297e možnost opakovaně použít volby -c a -f v psql]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53874c5228fe16589a4d01b3e1fab3678e0fd8e3 funkce pg_size_bytes]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3187d6de0e5a9e805b27c48437897e8c39071d45 funkce parse_ident]<br /> * [http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5c3c3cd0a3046339597a03bc708cb5530dc07059 strukturované výjimky v PLPythonu]<br /> <br /> ===PostgreSQL 10 (Release date: 2017-10-05)===<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fcec6caafa2346b6c9d3ad5065e417733bd63cd9 XMLTABLE funkce pro generování tabulky z XML dokumentu]<br /> <br /> ===PostgreSQL 11 (Release date: 2018-10-18)===<br /> * PSQL_PAGER - možnost nastavit specifický pager pouze pro psql<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=49ca462eb165dea297f1f110e8eac064308e9d51 popis výsledku dotazu]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b8060e41b5994a3cffb3ececaab10ed39b8d5dfd parametr funkce bude v chybových hláškách pojmenovaný jménem]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ed22fb8b0091deea23747310fa7609079a96cf82 type cache pro funkci concat]<br /> <br /> ===PostgreSQL 12 (Release date: 2019-10-03)===<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f7cb2842bf47715133b40e4a503f35dbe60d1b72 plan_cache_mode řízení chování plan cache]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=167075be3ab1547e186096bb8e6e448cd8eea5af extra checks strict_multi_assignment, too_many_rows]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e0ef136d5235f39f5652c209c08a5d4322560e9c konzistentní volání plpgsql plugin API]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bbd5c207b960dd072445a3547f16abea0c27f726 jednoznačná identifikace příkazů PL/pgSQL]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=251cf2e27bec98274e8bb002608680bdc211319e preciznější zpracování výsledku vyhodnocení XPath výrazů]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1c5d9270e339662cdd78d51d0b859d4f0a11aa91 přehlad partitions \dP v psql]<br /> <br /> ===PostgreSQL 13 (Release date: 2020-9-24)===<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1379fd537f9fc7941c8acff8c879ce3636dbdb77 DROP DATABASE FORCE]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=20d6225d1656102534a73d9675bc531ff0e5203b funkce min_scale, trim_scale]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24e2885ee304cb6a94fdfc25a1a108344ed9f4f7 další třída polymorfních typů s vynuceným přetypováním anycompatible]<br /> <br /> ===PostgreSQL 14 (Release date: 2021-10-??)===<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=66f163068030b5c5fe792a0daee27822dac43791 funkce string_to_table]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f0e4ec74e452f55922b52f50da4ba4834771a268 fix memory leak příkazu CALL]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ee895a655ce4341546facd6f23e3e8f2931b96bf zpristupneni plan cache pro prikaz CALL]<br /> * [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f37fec837ce8bf7af408ba66d32099e5a0182402 funkce unistr]<br /> <br /> ==Neakceptované patche==<br /> *PL/pgPSM - implemetace jazyka uložených procedur specifikovaného ve standardu SQL/PSM pro PostgreSQL - do core se nedostalo z důvodu duplikování kódu PL/pgSQL - jádro plpgpsm vychází z plpgsql. Čeká se na refaktoring plpgsql, tak aby bylo možné sdílet kód mezi plpgsql a plpgpsm. (Nyní po 10 letech od implementace je jasné, že očekávání vkládaná do PL/PSM se nenaplnila, a že chybějící podpora PL/PSM v Postgresu nikoho netrápí. Navíc existují transpilery).<br /> *Obfuscace zdrojového kódu procedur - funkční, do kódu se nedostalo v obavě ze závislosti v core na šifrách, které donedávna spadaly pod embargo USA.<br /> <br /> ==Kódy pro PostgreSQL mimo core==<br /> *[http://pgfoundry.org/projects/orafce/ Orafce]<br /> *epsql<br /> *[http://pgfoundry.org/projects/pstcollection/ PLToolbox] - [[PL toolbox|dokumentace]]<br /> *[http://kix.fsv.cvut.cz/~stehule/download/plpgsql_lint_2011-07-20.tgz plpgsql_lint]<br /> *[https://github.com/okbob/plpgsql_check plpgsql_check - next generation of plpgsql_lint]<br /> *[https://github.com/okbob/plpsm0 plpsm]<br /> *[https://github.com/okbob/pspg pspg] - pager napsaný pro práci s relační databází</div>

imported>Pavel