http://postgres.cz/index.php?action=history&feed=atom&title=Patche_17 2026-05-12T22:43:12Z Historie editací této stránky MediaWiki 1.43.3 http://postgres.cz/index.php?title=Patche_17&diff=1103&oldid=prev 2024-04-06T16:34:44Z

<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 6. 4. 2024, 16:34</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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=5bf748b86bc6786a3fc57fc7ce296c37da6564b0 - vylepseni indexu</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1102:rev-1103:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1102&oldid=prev 2024-04-04T16:36:25Z

<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. 4. 2024, 16:36</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</del></div></td><td colspan="2" class="diff-side-added"></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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</del></div></td><td colspan="2" class="diff-side-added"></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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Řádek 79:</td> <td colspan="2" class="diff-lineno">Řádek 77:</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=de3600452b61d1bc3967e9e37e86db8956c8f577 - JSON_TABLE&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=de3600452b61d1bc3967e9e37e86db8956c8f577 - JSON_TABLE&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk&lt;/s&gt;</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1101:rev-1102:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1101&oldid=prev 2024-04-04T15:25:33Z

<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. 4. 2024, 15:25</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=de3600452b61d1bc3967e9e37e86db8956c8f577 - JSON_TABLE</del></div></td><td colspan="2" class="diff-side-added"></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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Řádek 79:</td> <td colspan="2" class="diff-lineno">Řádek 78:</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=de3600452b61d1bc3967e9e37e86db8956c8f577 - JSON_TABLE&lt;/s&gt;</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1100:rev-1101:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1100&oldid=prev 2024-04-04T11:35:56Z

<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. 4. 2024, 11:35</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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=de3600452b61d1bc3967e9e37e86db8956c8f577 - JSON_TABLE</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1099:rev-1100:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1099&oldid=prev 2024-04-04T06:53:06Z

<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. 4. 2024, 06:53</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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><del style="font-weight: bold; text-decoration: none;">* https://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/</del></div></td><td colspan="2" class="diff-side-added"></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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1098:rev-1099:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1098&oldid=prev 2024-04-04T06:50:55Z

<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. 4. 2024, 06:50</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach</del></div></td><td colspan="2" class="diff-side-added"></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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/</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://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Řádek 79:</td> <td colspan="2" class="diff-lineno">Řádek 78:</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach&lt;/s&gt;</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1097:rev-1098:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1097&oldid=prev 2024-04-04T06:42:27Z

<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. 4. 2024, 06:42</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions</del></div></td><td colspan="2" class="diff-side-added"></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=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach</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=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Řádek 79:</td> <td colspan="2" class="diff-lineno">Řádek 78:</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions&lt;/s&gt;</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1096:rev-1097:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1096&oldid=prev 2024-04-04T06:13:08Z

<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. 4. 2024, 06:13</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3">Řádek 3:</td> <td colspan="2" class="diff-lineno">Řádek 3:</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/</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://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu</del></div></td><td colspan="2" class="diff-side-added"></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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Řádek 79:</td> <td colspan="2" class="diff-lineno">Řádek 78:</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f5a227895e178bf528b18f82bbe554435fb3e64f - option log verbosity do COPY&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f5a227895e178bf528b18f82bbe554435fb3e64f - option log verbosity do COPY&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu&lt;/s&gt;</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1095:rev-1096:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1095&oldid=prev 2024-04-04T06:12:08Z

<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. 4. 2024, 06:12</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions</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=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu</del></div></td><td colspan="2" class="diff-side-added"></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=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach</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=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Řádek 79:</td> <td colspan="2" class="diff-lineno">Řádek 78:</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b725b7eec431f7394d63abe621170efe3fcdcda4 - prejmenovani parametru prikazu COPY (fault tolerant)&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b725b7eec431f7394d63abe621170efe3fcdcda4 - prejmenovani parametru prikazu COPY (fault tolerant)&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f5a227895e178bf528b18f82bbe554435fb3e64f - option log verbosity do COPY&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f5a227895e178bf528b18f82bbe554435fb3e64f - option log verbosity do COPY&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu&lt;/s&gt;</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1094:rev-1095:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_17&diff=1094&oldid=prev 2024-04-03T12:39:47Z

<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 3. 4. 2024, 12:39</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions</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=8c852ba9a4347c4778cc610ad5a9cb50ea701b5c - constraint exclusion na partitions</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=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu</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=dc212340058b4e7ecfc5a7a81ec50e7a207bf288 - podpora inkrementalniho backupu</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=9e2d8701194fa1d280b73c024759950c74c1c637 - priprava na fault tolerant COPY</del></div></td><td colspan="2" class="diff-side-added"></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=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach</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=699586315704a8268808e3bdba4cb5924a038c49 - podpora identity sloupcu na partitiovanych tabulkach</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b725b7eec431f7394d63abe621170efe3fcdcda4 - prejmenovani parametru prikazu COPY (fault tolerant)</del></div></td><td colspan="2" class="diff-side-added"></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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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=46a0cd4cefb4d9b462d8cc4df5e7ecdd190bea92 - možnost přidání klauzule WITHOUT OVERLAP do PK</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://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/</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://www.depesz.com/2024/02/07/waiting-for-postgresql-17-support-identity-columns-in-partitioned-tables/</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=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu</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=2041bc4276c95ac014510032e622a4baf70b29f1 - identifikace fullbackupu</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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=34768ee361656841a122f1c8d52a2ad753612feb - temporal fk</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><del style="font-weight: bold; text-decoration: none;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f5a227895e178bf528b18f82bbe554435fb3e64f - option log verbosity do COPY</del></div></td><td colspan="2" class="diff-side-added"></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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83d1b0c40ccda8955f1245087f0697652c4df86 - ON LOGIN trigger&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=519fc1bd9e9d7b408903e44f55f83f6db30742b7 - infinity interval&lt;/s&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l79">Řádek 79:</td> <td colspan="2" class="diff-lineno">Řádek 76:</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0452b461bc405e6d35d8a14c02813c15e28ae516 - optimalizace řazení vícesloupcového GROUP BY&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0452b461bc405e6d35d8a14c02813c15e28ae516 - optimalizace řazení vícesloupcového GROUP BY&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f6d4c9cf162b70f2837fb6c2a83e80a3f3410695 - COPY FROM FORCE NOT NULL *&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f6d4c9cf162b70f2837fb6c2a83e80a3f3410695 - COPY FROM FORCE NOT NULL *&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=9e2d8701194fa1d280b73c024759950c74c1c637 - priprava na fault tolerant COPY&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b725b7eec431f7394d63abe621170efe3fcdcda4 - prejmenovani parametru prikazu COPY (fault tolerant)&lt;/s&gt;</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;">* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f5a227895e178bf528b18f82bbe554435fb3e64f - option log verbosity do COPY&lt;/s&gt;</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1093:rev-1094:php=table --> </table>

PavelStehule