Re: PostgreSQL for VAX on NetBSD/OpenBSD

Attached is the pg_regress diff. I believe they are all user-visible
effects of non-iee fp math though I would have expected the rounding
to work right and I'm not clear how gist ends up returning rows in a
different order.

There are still two local changes. The SIGILL handler which is set to
the FPE handler function and initdb is forced to allocate a smaller
shared memory and smaller number of connections to avoid the kernel
panic. I'm running the regression tests with MAX_CONNECTIONS=2.

They take 7h20m to run the regression tests (The git pull actually
only took 7m and rebuilding took three hours)

test tablespace ... ok
parallel group (20 tests, in groups of 2): char boolean name varchar
int2 text int4 int8 oid float4 float8 bit txid numeric uuid enum money
rangetypes regproc pg_lsn
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... FAILED
int4 ... FAILED
int8 ... FAILED
oid ... ok
float4 ... FAILED
float8 ... FAILED
bit ... ok
numeric ... FAILED
txid ... ok
uuid ... ok
enum ... ok
money ... ok
rangetypes ... ok
pg_lsn ... ok
regproc ... ok
test strings ... ok
test numerology ... FAILED
parallel group (20 tests, in groups of 2): lseg point box line path
polygon circle date time timetz timestamp timestamptz abstime interval
reltime tinterval macaddr inet comments tstypes
point ... FAILED
lseg ... ok
line ... FAILED
box ... ok
path ... ok
polygon ... FAILED
circle ... FAILED
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... FAILED
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
macaddr ... ok
tstypes ... ok
comments ... ok
parallel group (6 tests, in groups of 2): geometry horology regex
oidjoins type_sanity opr_sanity
geometry ... FAILED
horology ... ok
regex ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test insert ... ok
test insert_conflict ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
parallel group (2 tests): copyselect copy
copy ... ok
copyselect ... ok
parallel group (2 tests): create_operator create_misc
create_misc ... ok
create_operator ... ok
parallel group (2 tests): create_view create_index
create_index ... ok
create_view ... ok
parallel group (13 tests, in groups of 2): create_aggregate
create_function_3 create_cast constraints triggers inherit typed_table
create_table_like drop_if_exists vacuum rolenames updatable_views
roleattributes
create_aggregate ... ok
create_function_3 ... ok
create_cast ... ok
constraints ... ok
triggers ... ok
inherit ... ok
create_table_like ... ok
typed_table ... ok
vacuum ... ok
drop_if_exists ... ok
updatable_views ... FAILED
rolenames ... ok
roleattributes ... ok
test sanity_check ... ok
test errors ... ok
test select ... ok
parallel group (20 tests, in groups of 2): select_distinct
select_into select_distinct_on select_implicit select_having subselect
case union aggregates join random transactions portals arrays
hash_index btree_index namespace update delete prepared_xacts
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... FAILED
case ... ok
join ... ok
aggregates ... FAILED
transactions ... ok
random ... ok
portals ... ok
arrays ... FAILED
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
prepared_xacts ... ok
delete ... ok
parallel group (14 tests, in groups of 2): gin brin spgist gist
security_label privileges collate matview lock replica_identity
object_address rowsecurity groupingsets tablesample
brin ... ok
gin ... ok
gist ... FAILED
spgist ... ok
privileges ... ok
security_label ... ok
collate ... ok
matview ... ok
lock ... ok
replica_identity ... ok
rowsecurity ... ok
object_address ... ok
tablesample ... ok
groupingsets ... ok
parallel group (5 tests, in groups of 2): alter_operator
alter_generic psql misc async
alter_generic ... ok
alter_operator ... ok
misc ... ok
psql ... ok
async ... ok
test rules ... ok
parallel group (19 tests, in groups of 2): portals_p2 select_views
cluster foreign_key guc dependency combocid bitmapops tsdicts tsearch
window foreign_data xmlmap functional_deps advisory_lock json jsonb
indirect_toast equivclass
select_views ... ok
portals_p2 ... ok
foreign_key ... ok
cluster ... ok
dependency ... ok
guc ... ok
bitmapops ... ok
combocid ... ok
tsearch ... ok
tsdicts ... ok
foreign_data ... ok
window ... FAILED
xmlmap ... ok
functional_deps ... ok
advisory_lock ... ok
json ... FAILED
jsonb ... ok
indirect_toast ... ok
equivclass ... ok
parallel group (19 tests, in groups of 2): limit plancache copy2
plpgsql temp domain prepare rangefuncs conversion without_oid truncate
alter_table sequence polymorphism returning rowtypes with largeobject
xml
plancache ... ok
limit ... ok
plpgsql ... ok
copy2 ... ok
temp ... ok
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... ok
alter_table ... ok
sequence ... ok
polymorphism ... ok
rowtypes ... ok
returning ... ok
largeobject ... ok
with ... ok
xml ... ok
test event_trigger ... ok
test stats ... ok
============== shutting down postmaster ==============