注意： 下面的信息用于帮助那些希望从 postgres95 1.01 和 1.02 向 postgres95 1.02.1 迁移的用户．如果你刚刚开始使用 postgres95 1.02.1 并且不需要迁移旧的数据库，那么你不需要阅读下面的部分．
向1.01或1.02数据库中增加新的内建函数．方法是在你的1.01或1.02的数据库上运行新的1.02.1服务器然后运行文末的查询．这些工作可以很轻松的通过 psql 来完成．如果你的1.01或1.02数据库叫 "testdb" 并且你已经把本文末尾的命令剪切下来并存入到文件 addfunc.sql 里，那么：
% psql testdb -f addfunc.sql那些从1.02数据库升级的人们在执行文件中这两个语句时会看到警告信息，因为它们已经在1.02中出现了．这些警告不会产生问题．
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);
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 Ports * added SolarisX86 port * added BSDI 2.1 port * added DGUX port