6.4 error with oid type

Started by Fuad Abdallahabout 27 years ago1 messages
#1Fuad Abdallah
abdallah@mpiz-koeln.mpg.de

Hi,

after posting this problem to the admin and general group i hope it's ok
to summarize the problem to this list.

I have build postgres 6.4 under irix 6.5.1 with the irix cc 7.2.1
The regression test works without problem but many things still seem to be
broken:

1) destroying a database fails with the following error
ERROR: typeidTypeRelid: Invalid type - oid = 0
destroydb: database destroy failed on test.

2) pg_dump fails
pg_dump error in finding the template1 database

the debug info from the server shows
StartTransactionCommand
query: SELECT oid from pg_database where datname = 'template1'
ProcessQuery
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 422466 exited with
status 139
/usr/local/pgsql/bin/postmaster: CleanupProc: reinitializing shared memory
and semaphores
shmem_exit(0) [#0]

3) vacuum a database reports something unusual
NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES
(915) IS NOT THE SAME AS HEAP' (937)

4) selecting psql \dd command fails
ERROR: typeidTypeRelid: Invalid type - oid = 0

Overall, i guess the handling of the oid type does not seem to work,
selecting oid from any table
crashes the server :-(

I have checked the versions of bison and flex
bison --version
GNU Bison version 1.25
flex --version
flex version 2.5.4

so this is probably not the reason.

The same problem has been reported for DEC OS 4.0d (if i remember it
correctly, using cc -std1).

I would be _very_ pleased if somebody could check this error. If it is
required, a developer can get access to the postgres account on the
machine i used to build postgres.

Best Regards,
Fuad

--
Fuad Abdallah
Max-Planck-Institut fuer Zuechtungsforschung / ZWDV
Tel.: 0221/5062-739 / Priv: 0221/584563