Базы данныхИнтернетКомпьютерыОперационные системыПрограммированиеСетиСвязьРазное
Поиск по сайту:
Подпишись на рассылку:

Назад в раздел


> > >Выпуск v1.02 > NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.18"> REL="HOME"
TITLE="Руководство администратора по PostgreSQL"
HREF="671.html"> REL="UP"
TITLE="Замечания по выпускам"
HREF="5861.html"> REL="PREVIOUS"
TITLE="Выпуск v1.09"
HREF="5874.html"> REL="NEXT"
TITLE="Выпуск v1.01"
HREF="5876.html">

BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
> > COLSPAN="3"
ALIGN="center"
>Руководство администратора по PostgreSQL
>
> > WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
> HREF="5874.html"
>Предыдущий
>
> WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Глава 15. Замечания по выпускам
> WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
> HREF="5876.html"
>Следующий
>
>
> > ALIGN="LEFT"
WIDTH="100%"> CLASS="SECT1"
> NAME="AEN2203"
>Выпуск v1.02
>
> CLASS="SECT2"
> NAME="AEN2205"
>Migration from v1.02 to v1.02.1
>
> >Here is a new migration file for 1.02.1. It includes the 'copy' change
and a script to convert old ascii files.
> CLASS="NOTE"
> > >Note: >The following notes are for the benefit of users who want to migrate
databases from postgres95 1.01 and 1.02 to postgres95 1.02.1.
> >If you are starting afresh with postgres95 1.02.1 and do not need
to migrate old databases, you do not need to read any further.
>
> >In order to upgrade older postgres95 version 1.01 or 1.02 databases to
version 1.02.1, the following steps are required:
> TYPE="1"
> > >Start up a new 1.02.1 postmaster > > > >Add the new built-in functions and operators of 1.02.1 to 1.01 or 1.02
databases. This is done by running the new 1.02.1 server against
your own 1.01 or 1.02 database and applying the queries attached at
the end of thie file. This can be done easily through psql. If your
1.01 or 1.02 database is named "testdb" and you have cut the commands
from the end of this file and saved them in addfunc.sql:
CLASS="PROGRAMLISTING"
> % psql testdb -f addfunc.sql
>

Those upgrading 1.02 databases will get a warning when executing the
last two statements in the file because they are already present in 1.02. This is
not a cause for concern.
>
>
> CLASS="SECT2"
> NAME="AEN2218"
>Dump/Reload Procedure
>
> >If you are trying to reload a pg_dump or text-mode 'copy tablename to
stdout' generated with a previous version, you will need to run the
attached sed script on the ASCII file before loading it into the
database. The old format used '.' as end-of-data, while '.' is now the
end-of-data marker. Also, empty strings are now loaded in as '' rather
than NULL. See the copy manual page for full details.

CLASS="PROGRAMLISTING"
> sed 's/^.$/\./g' <in_file >out_file
>
> >If you are loading an older binary copy or non-stdout copy, there is no
end-of-data character, and hence no conversion necessary.

CLASS="PROGRAMLISTING"
>-- following lines added by agc to reflect the case-insensitive
-- regexp searching for varchar (in 1.02), and bpchar (in 1.02.1)
create operator ~* (leftarg = bpchar, rightarg = text, procedure = texticregexeq);
create operator !~* (leftarg = bpchar, rightarg = text, procedure = texticregexne);
create operator ~* (leftarg = varchar, rightarg = text, procedure = texticregexeq);
create operator !~* (leftarg = varchar, rightarg = text, procedure = texticregexne);
>
> CLASS="SECT2"
> NAME="AEN2224"
>Подробный список изменений
>
> > CLASS="PROGRAMLISTING"
>Source code maintenance and development
* worldwide team of volunteers
* the source tree now in CVS at ftp.ki.net

Enhancements
* psql (and underlying libpq library) now has many more options for
formatting output, including HTML
* pg_dump now output the schema and/or the data, with many fixes to
enhance completeness.
* psql used in place of monitor in administration shell scripts.
monitor to be depreciated in next release.
* date/time functions enhanced
* NULL insert/update/comparison fixed/enhanced
* TCL/TK lib and shell fixed to work with both tck7.4/tk4.0 and tcl7.5/tk4.1

Bug Fixes (almost too numerous to mention)
* indexes
* storage management
* check for NULL pointer before dereferencing
* Makefile fixes

New Переносимость
* added SolarisX86 port
* added BSDI 2.1 port
* added DGUX port
>
> ALIGN="LEFT"
WIDTH="100%"> WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
> > WIDTH="33%"
ALIGN="left"
VALIGN="top"
> HREF="5874.html"
>Предыдущий
>
> WIDTH="34%"
ALIGN="center"
VALIGN="top"
> HREF="671.html"
>Начало
>
> WIDTH="33%"
ALIGN="right"
VALIGN="top"
> HREF="5876.html"
>Следующий
>
>
> > WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Выпуск v1.09
> WIDTH="34%"
ALIGN="center"
VALIGN="top"
> HREF="5861.html"
>В начало главы
>
> WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Выпуск v1.01
>
>
> > >

  • Главная
  • Новости
  • Новинки
  • Скрипты
  • Форум
  • Ссылки
  • О сайте




  • Emanual.ru – это сайт, посвящённый всем значимым событиям в IT-индустрии: новейшие разработки, уникальные методы и горячие новости! Тонны информации, полезной как для обычных пользователей, так и для самых продвинутых программистов! Интересные обсуждения на актуальные темы и огромная аудитория, которая может быть интересна широкому кругу рекламодателей. У нас вы узнаете всё о компьютерах, базах данных, операционных системах, сетях, инфраструктурах, связях и программированию на популярных языках!
     Copyright © 2001-2024
    Реклама на сайте