Thread

6.4 error with oid type

Fuad Abdallah <abdallah@mpiz-koeln.mpg.de> — 1998-11-10T20:25:42Z

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