diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-02-13 04:40:06 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-02-13 04:40:06 +0000 |
| commit | 1decc208ac813c8cd0398d91c613a56672aa788d (patch) | |
| tree | ce805fdd544c0f7de84d9dd01634ca0ce0590209 | |
| parent | 1e376bfb5e96ae40bb03cbad48cca9f3ee071189 (diff) | |
| download | postgresql-1decc208ac813c8cd0398d91c613a56672aa788d.tar.gz postgresql-1decc208ac813c8cd0398d91c613a56672aa788d.zip | |
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. Sorry
Jan
| -rw-r--r-- | HISTORY | 4 | ||||
| -rw-r--r-- | doc/src/sgml/release.sgml | 4 |
2 files changed, 4 insertions, 4 deletions
@@ -462,8 +462,6 @@ Query Changes In prior releases, LIMIT/OFFSET could only use constants, not expressions. * Implement CREATE TABLE AS EXECUTE (Neil, Peter) - * Don't lock referenced row when "UPDATE" doesn't change foreign - key's value (Jan) _________________________________________________________________ Object Manipulation Changes @@ -940,6 +938,8 @@ Changes * Repair sometimes-incorrect computation of StartUpID after a crash * Avoid slowness with lots of deferred triggers in one transaction (Stephan) + * Don't lock referenced row when "UPDATE" doesn't change foreign + key's value (Jan) * Use "-fPIC" not "-fpic" on Sparc (Tom Callaway) * Repair lack of schema-awareness in contrib/reindexdb * Fix contrib/intarray error for zero-element result array (Teodor) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index cb0d8d8ba27..cdaabb0b893 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.254 2004/02/12 20:17:34 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.255 2004/02/13 04:40:06 momjian Exp $ --> <appendix id="release"> @@ -1056,7 +1056,6 @@ DROP SCHEMA information_schema CASCADE; <listitem> <para>Implement <literal>CREATE TABLE AS EXECUTE</literal> (Neil, Peter)</para> </listitem> - <listitem><para>Don't lock referenced row when <command>UPDATE</command> doesn't change foreign key's value (Jan)</para></listitem> </itemizedlist> </sect3> @@ -2090,6 +2089,7 @@ DROP SCHEMA information_schema CASCADE; <itemizedlist> <listitem><para>Repair sometimes-incorrect computation of StartUpID after a crash</para></listitem> <listitem><para>Avoid slowness with lots of deferred triggers in one transaction (Stephan)</para></listitem> +<listitem><para>Don't lock referenced row when <command>UPDATE</command> doesn't change foreign key's value (Jan)</para></listitem> <listitem><para>Use <command>-fPIC</command> not <command>-fpic</command> on Sparc (Tom Callaway)</para></listitem> <listitem><para>Repair lack of schema-awareness in contrib/reindexdb</para></listitem> <listitem><para>Fix contrib/intarray error for zero-element result array (Teodor)</para></listitem> |