Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit1decc20

Browse files
committed
Tom Lane wrote:
> momjian@svr1.postgresql.org (Bruce Momjian) writes:>> someone asked me about the FK deadlock fix, mentioned in the 7.3.3>> release notes as 3rd change:>>http://www.postgresql.org/docs/current/static/release-7-3-3.html>> Actually, that fix was available with 7.4, not 7.3. Don't know if we can>> retroactively change the release-notes though.>> This is completely erroneous, please undo it.>> 2003-05-21 14:14 tgl>> * src/: backend/utils/adt/ri_triggers.c,> test/regress/expected/foreign_key.out (REL7_3_STABLE): Back-patch> Jan's fix to avoid primary key lookup (and lock) if foreign key> does not change on UPDATE.Oh ... didn't know that you did a backpatch. SorryJan
1 parent1e376bf commit1decc20

File tree

2 files changed

+4
-4
lines changed

2 files changed

+4
-4
lines changed

‎HISTORY

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -462,8 +462,6 @@ Query Changes
462462
In prior releases, LIMIT/OFFSET could only use constants, not
463463
expressions.
464464
* Implement CREATE TABLE AS EXECUTE (Neil, Peter)
465-
* Don't lock referenced row when "UPDATE" doesn't change foreign
466-
key's value (Jan)
467465
_________________________________________________________________
468466

469467
Object Manipulation Changes
@@ -940,6 +938,8 @@ Changes
940938
* Repair sometimes-incorrect computation of StartUpID after a crash
941939
* Avoid slowness with lots of deferred triggers in one transaction
942940
(Stephan)
941+
* Don't lock referenced row when "UPDATE" doesn't change foreign
942+
key's value (Jan)
943943
* Use "-fPIC" not "-fpic" on Sparc (Tom Callaway)
944944
* Repair lack of schema-awareness in contrib/reindexdb
945945
* Fix contrib/intarray error for zero-element result array (Teodor)

‎doc/src/sgml/release.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.254 2004/02/12 20:17:34 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.255 2004/02/13 04:40:06 momjian Exp $
33
-->
44

55
<appendix id="release">
@@ -1056,7 +1056,6 @@ DROP SCHEMA information_schema CASCADE;
10561056
<listitem>
10571057
<para>Implement <literal>CREATE TABLE AS EXECUTE</literal> (Neil, Peter)</para>
10581058
</listitem>
1059-
<listitem><para>Don't lock referenced row when <command>UPDATE</command> doesn't change foreign key's value (Jan)</para></listitem>
10601059
</itemizedlist>
10611060
</sect3>
10621061

@@ -2090,6 +2089,7 @@ DROP SCHEMA information_schema CASCADE;
20902089
<itemizedlist>
20912090
<listitem><para>Repair sometimes-incorrect computation of StartUpID after a crash</para></listitem>
20922091
<listitem><para>Avoid slowness with lots of deferred triggers in one transaction (Stephan)</para></listitem>
2092+
<listitem><para>Don't lock referenced row when <command>UPDATE</command> doesn't change foreign key's value (Jan)</para></listitem>
20932093
<listitem><para>Use <command>-fPIC</command> not <command>-fpic</command> on Sparc (Tom Callaway)</para></listitem>
20942094
<listitem><para>Repair lack of schema-awareness in contrib/reindexdb</para></listitem>
20952095
<listitem><para>Fix contrib/intarray error for zero-element result array (Teodor)</para></listitem>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp