Subject: [PATCHES] to make regress.sh shell friendly to echo.

Hi,

I needed to make the following change to regress.sh to make it more
shell friendly.

The Solaris /bin/sh, and others, use \c to supress the newline.

what's being tested :)

Pointed out by: Christopher Hicks <chicks@chicks.net>

the DROP TABLE calls from the destroy.sql file to the 'types' .sql files,
so that they are self-contained

btree_index, hash_index and misc all fail as there seems to be missing
a 'misc.out' expected file...have asked Thomas for one...

=============== destroying old regression database... =================
=============== creating new regression database...   =================
=============== running regression queries...         =================
create_function_1 .. ok
create_type .. ok
create_table .. ok
create_function_2 .. ok

that are created should only exist as long as the test requires them...

things are just toooooo spread around

debugging is a little (well, alot!) easier

away from one big massive confusing file

Pointed out by: adrian@waltham.harvard.net

do this completely last time and Thomas is creating patches on files that
aren't supposed to exist :(

Remove bin/Makefile.global since it wasn't actually *doing* anything
that Makefile.global hadn't already done

Here are patches which should help fix timezone problems in the
datetime and abstime code. Also, I repatched varlena.c to add in
some comments and a little error checking on top of Vadim's earlier
repairs. There are slight mods to the circle data type to have the
distance operator between circles measure the distance between
closest points rather than between centers.

Subject: [PATCHES] Patches for compiling 6.1 on Digital Unix 3.2c

Attached to this message are the patches I needed to compile 6.1 cleanly
under Digital Unix 3.2c with DEC cc.

I hope these are the last ones. At least, the number of files needing a
patch has decreased noticeably since I sent my previous patches. Nice work
:-)

One of the patches is a bug fix, but I'm including it here anyway.

With these patches applied, the beast seems to work properly. However,
I've done only some preliminary tests. More on this later (but hopefully
before the April 30 deadline... :-)

postgres backend processes end up as so called zombies. It seems that
only Linux a.out (libc.4.6.27) systems are affected.


By:

Wolfgang Roth <roth@statistik.uni-mannheim.de>

Doug Neuhauser <doug@seismo.berkeley.edu> on April 15th

Added #define BTREE_VERSION_1.

     * npages = index_pages * selectivity_of_1st_attr_clause(s)

joininfo (in add_join_clause_info_to_rels()) : clause may be
commutted later.

nestloop's join clauses doesn't work in some cases:
         *    1. fix_indxqual_references may change varattno-s in
         *       inner_indxqual;
         *    2. clauses may be commuted

SET cost_heap(cost_index) TO ...

#define _CPU_INDEX_PAGE_WEIGHT_: 0.033 --> 0.017

tests now let you know if it is ok/failed :)

Satoshi Ishikawa <power@sekine.densi.gifu-u.ac.jp>