I tested it restoring my database with > 100000 BLOBS, and dumping it out.
But unfortunatly I can not restore it back due to problems in pg_dump.

--
Sincerely Yours,
Denis Perchine

src/template/unixware:

Larry Rosenman

flags for Solaris.  The test itself is straight from libtool.

source directory.  This involves mostly makefiles using $(srcdir) when they
might have used ".".  (Regression tests don't work with this, yet.)

Sort out usage of CPPFLAGS, CFLAGS (and CXXFLAGS).  Add "override" keyword
in most places, to preserve necessary flags even when the user overrode the
flags.

 Thanks to Henry "He Weiping (Laser Henry)" <laser@zhengmai.com.cn>
 for catching this.

Remove copy/paste redundant extra section with slight merge of content.

 time zones with embedded numerals (parsing to a meaninless "ZP 4"
 instead).
Support "SAT" as an Australian time zone if USE_AUSTRALIAN_RULES
 is defined.
Fix units in exposition on Julian calendar (from Lazer Henry I think...)

Remove lots of extraneous trailing ^Ms from pg_restore.sgml.

(without PageManagetSetMode -:))
Safe shuffle mode behaviour retained.

anywhere else that Makefile.shlib needs to modify CFLAGS to produce
valid code for a shared library.  I'm not real clear on *why* the use
of override causes make to ignore the later attempt to assign
CFLAGS		+=
but it indubitably does --- at least on gmake 3.79.1.  gmake bug?

This patch forces the use of 'DROP VIEW' to destroy views.

It also changes the syntax of DROP VIEW to
DROP VIEW v1, v2, ...
to match the syntax of DROP TABLE.

Some error messages were changed so this patch also includes changes to the
appropriate expected/*.out files.

Doc changes for 'DROP TABLE" and 'DROP VIEW' are included.


--
Mark Hollomon

LockRelId - ie physical information, not logical. It's required
for WAL. Regression tests passed.

the fact that CREATE FUNCTION and CREATE AGGREGATE now allow array
types to be named like int4[] rather than _int4.

(i.e., /usr/local/pgsql/etc by default).

* doc/src/sgml/installation.sgml: ditto.

* src/test/regress/README: Regenerate.

* doc/src/sgml/docguide.sgml: Explain how it was done.  Explain how
INSTALL and HISTORY are (now) generated.

* doc/src/sgml/Makefile: Implement HISTORY generation to be analoguous
to INSTALL.

update website references

I prepared and tested a patch vs. 7.0.2, and it works fine. I've added
another option which allows users to have their own service file in
~/.pg_service.conf, which might come handy sometimes.

Mario Weilguni

I have noticed that there are some identical files in
postgresql-7.0.2/src/test/regress/expected/

> diff float8-cygwin.out float8-small-is-zero.out #I recommend deleting
float8-cygwin.out
> diff geometry-cygwin-precision.out geometry-solaris-precision.out #I
recommend deleting geometry-cygwin-precision.out

below is the diff of postgresql-7.0.2/src/test/regress/resultmap
that has the above files deleted plus the addition of an alpha regression
test built with alphaev56-dec-osf4.0e/2.95.2/ . The alpha geometry
regression file is attached

11c11
< float8/i.86-pc-cygwin*=float8-cygwin
---
> float8/i.86-pc-cygwin*=float8-small-is-zero
18c18
< geometry/i.86-pc-cygwin*=geometry-cygwin-precision
---
> geometry/i.86-pc-cygwin*=geometry-solaris-precision
21a22
> geometry/alpha.*-dec-osf=geometry-alpha-precision



Ricardo Muggli
Systems Manager
Information and Technology Services
Minnesota State University, Mankato