1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="release.html"><LINK
19
HREF="release-1-09.html"><LINK
22
HREF="release-1-01.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
57
HREF="release-1-09.html"
74
>Appendix E. Release Notes</TD
90
HREF="release-1-01.html"
105
>E.191. Release 1.02</A
123
>E.191.1. Migration from version 1.02 to version 1.02.1</A
126
>Here is a new migration file for 1.02.1. It includes the 'copy' change
127
and a script to convert old <ACRONYM
138
>The following notes are for the benefit of users who want to migrate
142
> 1.01 and 1.02 to <SPAN
147
>If you are starting afresh with <SPAN
150
> 1.02.1 and do not need
151
to migrate old databases, you do not need to read any further.</P
155
>In order to upgrade older <SPAN
158
> version 1.01 or 1.02 databases to
159
version 1.02.1, the following steps are required:</P
167
>Start up a new 1.02.1 postmaster</P
172
>Add the new built-in functions and operators of 1.02.1 to 1.01 or 1.02
173
databases. This is done by running the new 1.02.1 server against
174
your own 1.01 or 1.02 database and applying the queries attached at
175
the end of the file. This can be done easily through <TT
179
1.01 or 1.02 database is named <TT
182
> and you have cut the commands
183
from the end of this file and saved them in <TT
188
CLASS="PROGRAMLISTING"
189
>% psql testdb -f addfunc.sql</PRE
192
Those upgrading 1.02 databases will get a warning when executing the
193
last two statements in the file because they are already present in 1.02. This is
194
not a cause for concern.</P
205
>E.191.2. Dump/Reload Procedure</A
208
>If you are trying to reload a pg_dump or text-mode, <TT
212
> generated with a previous version, you will need to run the
216
> script on the ASCII file before loading it into the
217
database. The old format used '.' as end-of-data, while '\.' is now the
218
end-of-data marker. Also, empty strings are now loaded in as '' rather
219
than NULL. See the copy manual page for full details.
222
CLASS="PROGRAMLISTING"
223
>sed 's/^\.$/\\./g' <in_file >out_file</PRE
226
>If you are loading an older binary copy or non-<SPAN
230
end-of-data character, and hence no conversion necessary.
233
CLASS="PROGRAMLISTING"
234
>-- following lines added by agc to reflect the case-insensitive
235
-- regexp searching for varchar (in 1.02), and bpchar (in 1.02.1)
236
create operator ~* (leftarg = bpchar, rightarg = text, procedure = texticregexeq);
237
create operator !~* (leftarg = bpchar, rightarg = text, procedure = texticregexne);
238
create operator ~* (leftarg = varchar, rightarg = text, procedure = texticregexeq);
239
create operator !~* (leftarg = varchar, rightarg = text, procedure = texticregexne);</PRE
252
CLASS="PROGRAMLISTING"
253
>Source code maintenance and development
254
* worldwide team of volunteers
255
* the source tree now in CVS at ftp.ki.net
258
* psql (and underlying libpq library) now has many more options for
259
formatting output, including HTML
260
* pg_dump now output the schema and/or the data, with many fixes to
261
enhance completeness.
262
* psql used in place of monitor in administration shell scripts.
263
monitor to be deprecated in next release.
264
* date/time functions enhanced
265
* NULL insert/update/comparison fixed/enhanced
266
* TCL/TK lib and shell fixed to work with both tck7.4/tk4.0 and tcl7.5/tk4.1
268
Bug Fixes (almost too numerous to mention)
271
* check for NULL pointer before dereferencing
275
* added SolarisX86 port
276
* added BSD/OS 2.1 port
277
* added DG/UX port</PRE
286
SUMMARY="Footer navigation table"
297
HREF="release-1-09.html"
315
HREF="release-1-01.html"
b'\\ No newline at end of file'