Thread: PostgreSQL 6.4.2: typeidTypeRelid error

I'd like to re-ask on this thread of a few days ago because I suspect
there is a deeper problem here that changing compilers simply "hides" in
some way.

I have a similar problem on Digital UNIX 4.0d with postgresql 6.4.2
compiled with vendor CC (V5.6 using "cc -std1" in compile).

% mv ${PGDATA} ${PGDATA}.foo
% mkdir $PGDATA
% initdb
% createdb test
% psql test
test=> create table val (v_num decimal);
test=> \d val
ERROR:  typeidTypeRelid: Invalid type - oid = 0

I have the same problem in an existing database that actually has data
in it - queries (seem to) work ok, but using psql to examine tables and
such is impossible.

The last discussion of this was on AIX 4.3.2 compiled with gcc, and the
fix (if I read the resolution of that thread properly) was to use the
vendor xlC on AIX instead.

http://www.postgresql.org/mhonarc/pgsql-hackers/1999-03/msg00066.html

This doesn't help me on Digital UNIX.

A previous mention of something similar (with no resolution I can find
in the archives) was in:

http://www.postgresql.org/mhonarc/pgsql-general/1999-01/msg00230.html

with pgsql 6.4.2 on LinuxPPC R4.

And before that (again, no resolution I can find) in:

http://www.postgresql.org/mhonarc/pgsql-hackers/1998-11/msg00215.html

on 6.4 where the problem is in IRIX with vendor cc and mentioned on
Digital UNIX 4.0b with the same "cc -std1" that I am using.

Any advice greatly appreciated.

Erik Riedel
Carnegie Mellon University
riedel@cmu.edu