|
A.26. 版本 1.02
A.26.1. 从 v1.02 迁移到 v1.02.11996-08-01 本文是用于 1.02.1 的新的迁移文件. 它包括 'copy' 的改变和一个用于转换旧的 ascii 文件的脚本.
要想从旧的 postgres95 版本 1.01 或 1.02 数据库向版本 1.02.1 升级, 需要进行下面步骤:
A.26.2. 倾倒/恢复过程如果你试图恢复用原先版本的 pg_dump 或文本模式的 'copy tablename to stdout'生成的数据, 你需要在那些ASCII 文件上运行下面的 sed 脚本,然后在恢复回数据库中去. 因为原先的格式用'.'作为数据结束符,而现在使用'\.'. 同样,现在空字符串用''进行装载,而不是NULL. 请参阅 copy 的手册页获取完整的细节描述. sed 's/^\.$/\\./g' <in_file >out_file 如果你从一个旧的二进制拷贝或非标准输出拷贝中恢复数据, 就不需要做上述转换,因为不存在数据结束符字符问题. -- 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); A.26.3. 修改列表
源代码管理和开发 * worldwide team of volunteers * the source tree now in CVS at ftp.ki.net 增强 * 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 修补(多得说不完) * indexes * storage management * check for NULL pointer before dereferencing * Makefile fixes 新移植 * added SolarisX86 port * added BSD/OS 2.1 port * added DG/UX port |