3
3
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
4
<title>E.43.�Release 6.2.1</title>
4
<title>E.72.�Release 6.2.1</title>
5
5
<link rel="stylesheet" href="stylesheet.css" type="text/css">
6
6
<link rev="made" href="pgsql-docs@postgresql.org">
7
<meta name="generator" content="DocBook XSL Stylesheets V1.64.1">
8
<link rel="home" href="index.html" title="PostgreSQL 8.0.0beta5 Documentation">
7
<meta name="generator" content="DocBook XSL Stylesheets V1.70.0">
8
<link rel="start" href="index.html" title="PostgreSQL 8.1.4 Documentation">
9
9
<link rel="up" href="release.html" title="Appendix�E.�Release Notes">
10
<link rel="previous" href="release-6-3.html" title="E.42.�Release 6.3">
11
<link rel="next" href="release-6-2.html" title="E.44.�Release 6.2">
10
<link rel="prev" href="release-6-3.html" title="E.71.�Release 6.3">
11
<link rel="next" href="release-6-2.html" title="E.73.�Release 6.2">
12
<link rel="copyright" href="ln-legalnotice.html" title="Legal Notice">
13
14
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="sect1" lang="en">
14
<div class="titlepage">
15
<div><div><h2 class="title" style="clear: both">
16
<a name="release-6-2-1"></a>E.43.�Release 6.2.1</h2></div></div>
15
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
16
<a name="release-6-2-1"></a>E.72.�Release 6.2.1</h2></div></div></div>
19
17
<div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
20
18
<h3 class="title">Release date</h3>
27
25
<div class="itemizedlist"><ul type="disc">
28
<li><p>Allow strings to span lines, per <span class="acronym">SQL92</span>.</p></li>
26
<li><p>Allow strings to span lines, per <acronym class="acronym">SQL92</acronym>.</p></li>
29
27
<li><p>Include example trigger function for inserting user names on table updates.</p></li>
31
29
<p>This is a minor bug-fix release on 6.2.
32
30
For upgrades from pre-6.2 systems, a full dump/reload is required.
33
31
Refer to the 6.2 release notes for instructions.</p>
34
32
<div class="sect2" lang="en">
35
<div class="titlepage">
36
<div><div><h3 class="title">
37
<a name="id2774835"></a>E.43.1.�Migration from version 6.2 to version 6.2.1</h3></div></div>
33
<div class="titlepage"><div><div><h3 class="title">
34
<a name="id896606"></a>E.72.1.�Migration from version 6.2 to version 6.2.1</h3></div></div></div>
40
35
<p>This is a minor bug-fix release. A dump/reload is not required from version 6.2,
41
36
but is required from any release prior to 6.2.</p>
42
37
<p>In upgrading from version 6.2, if you choose to dump/reload you will find that
43
38
avg(money) is now calculated correctly. All other bug fixes take effect
44
39
upon updating the executables.</p>
45
40
<p>Another way to avoid dump/reload is to use the following SQL command
46
from <tt class="command">psql</tt> to update the existing system table:
41
from <code class="command">psql</code> to update the existing system table:
49
44
<pre class="programlisting"> update pg_aggregate set aggfinalfn = 'cash_div_flt8'
51
46
<p>This will need to be done to every existing database, including template1.</p>
53
48
<div class="sect2" lang="en">
54
<div class="titlepage">
55
<div><div><h3 class="title">
56
<a name="id2774869"></a>E.43.2.�Changes</h3></div></div>
49
<div class="titlepage"><div><div><h3 class="title">
50
<a name="id896755"></a>E.72.2.�Changes</h3></div></div></div>
60
52
<pre class="programlisting">Allow TIME and TYPE column names(Thomas)
61
53
Allow larger range of true/false as boolean values(Thomas)