| | 67 | <sect1 id="release-8-2-9"> |
|---|
| | 68 | <title>Release 8.2.9</title> |
|---|
| | 69 | |
|---|
| | 70 | <note> |
|---|
| | 71 | <title>Release date</title> |
|---|
| | 72 | <simpara>2008-06-12</simpara> |
|---|
| | 73 | </note> |
|---|
| | 74 | |
|---|
| | 75 | <para> |
|---|
| | 76 | This release contains one serious and one minor bug fix over 8.2.8. |
|---|
| | 77 | For information about new features in the 8.2 major release, see |
|---|
| | 78 | <xref linkend="release-8-2"/>. |
|---|
| | 79 | </para> |
|---|
| | 80 | |
|---|
| | 81 | <sect2> |
|---|
| | 82 | <title>Migration to Version 8.2.9</title> |
|---|
| | 83 | |
|---|
| | 84 | <para> |
|---|
| | 85 | A dump/restore is not required for those running 8.2.X. |
|---|
| | 86 | However, if you are upgrading from a version earlier than 8.2.7, |
|---|
| | 87 | see the release notes for 8.2.7. |
|---|
| | 88 | </para> |
|---|
| | 89 | |
|---|
| | 90 | </sect2> |
|---|
| | 91 | |
|---|
| | 92 | <sect2> |
|---|
| | 93 | <title>Changes</title> |
|---|
| | 94 | |
|---|
| | 95 | <itemizedlist> |
|---|
| | 96 | |
|---|
| | 97 | <listitem> |
|---|
| | 98 | <para> |
|---|
| | 99 | Make <function>pg_get_ruledef()</function> parenthesize negative constants (Tom) |
|---|
| | 100 | </para> |
|---|
| | 101 | |
|---|
| | 102 | <para> |
|---|
| | 103 | Before this fix, a negative constant in a view or rule might be dumped |
|---|
| | 104 | as, say, <literal>-42::integer</literal>, which is subtly incorrect: it should |
|---|
| | 105 | be <literal>(-42)::integer</literal> due to operator precedence rules. |
|---|
| | 106 | Usually this would make little difference, but it could interact with |
|---|
| | 107 | another recent patch to cause |
|---|
| | 108 | <productname>PostgreSQL</productname> to reject what had been a valid |
|---|
| | 109 | <command>SELECT DISTINCT</command> view query. Since this could result in |
|---|
| | 110 | <application>pg_dump</application> output failing to reload, it is being treated |
|---|
| | 111 | as a high-priority fix. The only released versions in which dump |
|---|
| | 112 | output is actually incorrect are 8.3.1 and 8.2.7. |
|---|
| | 113 | </para> |
|---|
| | 114 | </listitem> |
|---|
| | 115 | |
|---|
| | 116 | <listitem> |
|---|
| | 117 | <para> |
|---|
| | 118 | Make <command>ALTER AGGREGATE ... OWNER TO</command> update |
|---|
| | 119 | <structname>pg_shdepend</structname> (Tom) |
|---|
| | 120 | </para> |
|---|
| | 121 | |
|---|
| | 122 | <para> |
|---|
| | 123 | This oversight could lead to problems if the aggregate was later |
|---|
| | 124 | involved in a <command>DROP OWNED</command> or <command>REASSIGN OWNED</command> |
|---|
| | 125 | operation. |
|---|
| | 126 | </para> |
|---|
| | 127 | </listitem> |
|---|
| | 128 | |
|---|
| | 129 | </itemizedlist> |
|---|
| | 130 | |
|---|
| | 131 | </sect2> |
|---|
| | 132 | </sect1> |
|---|
| | 133 | |
|---|
| | 4198 | <sect1 id="release-8-1-13"> |
|---|
| | 4199 | <title>Release 8.1.13</title> |
|---|
| | 4200 | |
|---|
| | 4201 | <note> |
|---|
| | 4202 | <title>Release date</title> |
|---|
| | 4203 | <simpara>2008-06-12</simpara> |
|---|
| | 4204 | </note> |
|---|
| | 4205 | |
|---|
| | 4206 | <para> |
|---|
| | 4207 | This release contains one serious and one minor bug fix over 8.1.12. |
|---|
| | 4208 | For information about new features in the 8.1 major release, see |
|---|
| | 4209 | <xref linkend="release-8-1"/>. |
|---|
| | 4210 | </para> |
|---|
| | 4211 | |
|---|
| | 4212 | <sect2> |
|---|
| | 4213 | <title>Migration to Version 8.1.13</title> |
|---|
| | 4214 | |
|---|
| | 4215 | <para> |
|---|
| | 4216 | A dump/restore is not required for those running 8.1.X. |
|---|
| | 4217 | However, if you are upgrading from a version earlier than 8.1.2, |
|---|
| | 4218 | see the release notes for 8.1.2. |
|---|
| | 4219 | </para> |
|---|
| | 4220 | |
|---|
| | 4221 | </sect2> |
|---|
| | 4222 | |
|---|
| | 4223 | <sect2> |
|---|
| | 4224 | <title>Changes</title> |
|---|
| | 4225 | |
|---|
| | 4226 | <itemizedlist> |
|---|
| | 4227 | |
|---|
| | 4228 | <listitem> |
|---|
| | 4229 | <para> |
|---|
| | 4230 | Make <function>pg_get_ruledef()</function> parenthesize negative constants (Tom) |
|---|
| | 4231 | </para> |
|---|
| | 4232 | |
|---|
| | 4233 | <para> |
|---|
| | 4234 | Before this fix, a negative constant in a view or rule might be dumped |
|---|
| | 4235 | as, say, <literal>-42::integer</literal>, which is subtly incorrect: it should |
|---|
| | 4236 | be <literal>(-42)::integer</literal> due to operator precedence rules. |
|---|
| | 4237 | Usually this would make little difference, but it could interact with |
|---|
| | 4238 | another recent patch to cause |
|---|
| | 4239 | <productname>PostgreSQL</productname> to reject what had been a valid |
|---|
| | 4240 | <command>SELECT DISTINCT</command> view query. Since this could result in |
|---|
| | 4241 | <application>pg_dump</application> output failing to reload, it is being treated |
|---|
| | 4242 | as a high-priority fix. The only released versions in which dump |
|---|
| | 4243 | output is actually incorrect are 8.3.1 and 8.2.7. |
|---|
| | 4244 | </para> |
|---|
| | 4245 | </listitem> |
|---|
| | 4246 | |
|---|
| | 4247 | <listitem> |
|---|
| | 4248 | <para> |
|---|
| | 4249 | Make <command>ALTER AGGREGATE ... OWNER TO</command> update |
|---|
| | 4250 | <structname>pg_shdepend</structname> (Tom) |
|---|
| | 4251 | </para> |
|---|
| | 4252 | |
|---|
| | 4253 | <para> |
|---|
| | 4254 | This oversight could lead to problems if the aggregate was later |
|---|
| | 4255 | involved in a <command>DROP OWNED</command> or <command>REASSIGN OWNED</command> |
|---|
| | 4256 | operation. |
|---|
| | 4257 | </para> |
|---|
| | 4258 | </listitem> |
|---|
| | 4259 | |
|---|
| | 4260 | </itemizedlist> |
|---|
| | 4261 | |
|---|
| | 4262 | </sect2> |
|---|
| | 4263 | </sect1> |
|---|
| | 4264 | |
|---|
| | 8067 | <sect1 id="release-8-0-17"> |
|---|
| | 8068 | <title>Release 8.0.17</title> |
|---|
| | 8069 | |
|---|
| | 8070 | <note> |
|---|
| | 8071 | <title>Release date</title> |
|---|
| | 8072 | <simpara>2008-06-12</simpara> |
|---|
| | 8073 | </note> |
|---|
| | 8074 | |
|---|
| | 8075 | <para> |
|---|
| | 8076 | This release contains one serious bug fix over 8.0.16. |
|---|
| | 8077 | For information about new features in the 8.0 major release, see |
|---|
| | 8078 | <xref linkend="release-8-0"/>. |
|---|
| | 8079 | </para> |
|---|
| | 8080 | |
|---|
| | 8081 | <sect2> |
|---|
| | 8082 | <title>Migration to Version 8.0.17</title> |
|---|
| | 8083 | |
|---|
| | 8084 | <para> |
|---|
| | 8085 | A dump/restore is not required for those running 8.0.X. |
|---|
| | 8086 | However, if you are upgrading from a version earlier than 8.0.6, |
|---|
| | 8087 | see the release notes for 8.0.6. |
|---|
| | 8088 | </para> |
|---|
| | 8089 | |
|---|
| | 8090 | </sect2> |
|---|
| | 8091 | |
|---|
| | 8092 | <sect2> |
|---|
| | 8093 | <title>Changes</title> |
|---|
| | 8094 | |
|---|
| | 8095 | <itemizedlist> |
|---|
| | 8096 | |
|---|
| | 8097 | <listitem> |
|---|
| | 8098 | <para> |
|---|
| | 8099 | Make <function>pg_get_ruledef()</function> parenthesize negative constants (Tom) |
|---|
| | 8100 | </para> |
|---|
| | 8101 | |
|---|
| | 8102 | <para> |
|---|
| | 8103 | Before this fix, a negative constant in a view or rule might be dumped |
|---|
| | 8104 | as, say, <literal>-42::integer</literal>, which is subtly incorrect: it should |
|---|
| | 8105 | be <literal>(-42)::integer</literal> due to operator precedence rules. |
|---|
| | 8106 | Usually this would make little difference, but it could interact with |
|---|
| | 8107 | another recent patch to cause |
|---|
| | 8108 | <productname>PostgreSQL</productname> to reject what had been a valid |
|---|
| | 8109 | <command>SELECT DISTINCT</command> view query. Since this could result in |
|---|
| | 8110 | <application>pg_dump</application> output failing to reload, it is being treated |
|---|
| | 8111 | as a high-priority fix. The only released versions in which dump |
|---|
| | 8112 | output is actually incorrect are 8.3.1 and 8.2.7. |
|---|
| | 8113 | </para> |
|---|
| | 8114 | </listitem> |
|---|
| | 8115 | |
|---|
| | 8116 | </itemizedlist> |
|---|
| | 8117 | |
|---|
| | 8118 | </sect2> |
|---|
| | 8119 | </sect1> |
|---|
| | 8120 | |
|---|
| | 12283 | <sect1 id="release-7-4-21"> |
|---|
| | 12284 | <title>Release 7.4.21</title> |
|---|
| | 12285 | |
|---|
| | 12286 | <note> |
|---|
| | 12287 | <title>Release date</title> |
|---|
| | 12288 | <simpara>2008-06-12</simpara> |
|---|
| | 12289 | </note> |
|---|
| | 12290 | |
|---|
| | 12291 | <para> |
|---|
| | 12292 | This release contains one serious bug fix over 7.4.20. |
|---|
| | 12293 | For information about new features in the 7.4 major release, see |
|---|
| | 12294 | <xref linkend="release-7-4"/>. |
|---|
| | 12295 | </para> |
|---|
| | 12296 | |
|---|
| | 12297 | <sect2> |
|---|
| | 12298 | <title>Migration to Version 7.4.21</title> |
|---|
| | 12299 | |
|---|
| | 12300 | <para> |
|---|
| | 12301 | A dump/restore is not required for those running 7.4.X. |
|---|
| | 12302 | However, if you are upgrading from a version earlier than 7.4.11, |
|---|
| | 12303 | see the release notes for 7.4.11. |
|---|
| | 12304 | </para> |
|---|
| | 12305 | |
|---|
| | 12306 | </sect2> |
|---|
| | 12307 | |
|---|
| | 12308 | <sect2> |
|---|
| | 12309 | <title>Changes</title> |
|---|
| | 12310 | |
|---|
| | 12311 | <itemizedlist> |
|---|
| | 12312 | |
|---|
| | 12313 | <listitem> |
|---|
| | 12314 | <para> |
|---|
| | 12315 | Make <function>pg_get_ruledef()</function> parenthesize negative constants (Tom) |
|---|
| | 12316 | </para> |
|---|
| | 12317 | |
|---|
| | 12318 | <para> |
|---|
| | 12319 | Before this fix, a negative constant in a view or rule might be dumped |
|---|
| | 12320 | as, say, <literal>-42::integer</literal>, which is subtly incorrect: it should |
|---|
| | 12321 | be <literal>(-42)::integer</literal> due to operator precedence rules. |
|---|
| | 12322 | Usually this would make little difference, but it could interact with |
|---|
| | 12323 | another recent patch to cause |
|---|
| | 12324 | <productname>PostgreSQL</productname> to reject what had been a valid |
|---|
| | 12325 | <command>SELECT DISTINCT</command> view query. Since this could result in |
|---|
| | 12326 | <application>pg_dump</application> output failing to reload, it is being treated |
|---|
| | 12327 | as a high-priority fix. The only released versions in which dump |
|---|
| | 12328 | output is actually incorrect are 8.3.1 and 8.2.7. |
|---|
| | 12329 | </para> |
|---|
| | 12330 | </listitem> |
|---|
| | 12331 | |
|---|
| | 12332 | </itemizedlist> |
|---|
| | 12333 | |
|---|
| | 12334 | </sect2> |
|---|
| | 12335 | </sect1> |
|---|
| | 12336 | |
|---|