Обсуждение: PostgreSQL 6.4.2 on AIX 4.3.2: typeidTypeRelid error

I've seen several postings about this, but no resolution. I've
filed another bug report.

If someone has a fix for this, let me know.

Thanks.

_______


============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : David Favor
Your email address      : dfavor@corridor.com

Category                : runtime: back-end
Severity                : critical

Summary: destroydb fails with ERROR:  typeidTypeRelid: Invalid type - oid = 0

System Configuration
--------------------
  Operating System   : AIX 432

  PostgreSQL version : 6.4.2

  Compiler used      : gcc version egcs-2.93.08 19990214

Hardware:
---------
AIX aasc24 3 4 00FFFFFF4C00 (Power PC)

Versions of other tools:
------------------------
gmake - 3.77
bison - 1.25
flex  - 2.5.4

--------------------------------------------------------------------------

Problem Description:
--------------------
template1=> create database foo;
CREATEDB
template1=> drop database foo;
ERROR:  typeidTypeRelid: Invalid type - oid = 0
ERROR:  typeidTypeRelid: Invalid type - oid = 0
template1=> \q

> I've seen several postings about this, but no resolution. I've
> filed another bug report.
> Problem Description:
> --------------------
> template1=> create database foo;
> CREATEDB
> template1=> drop database foo;
> ERROR:  typeidTypeRelid: Invalid type - oid = 0
> ERROR:  typeidTypeRelid: Invalid type - oid = 0
> template1=> \q

You have a damaged database afaik. Can you reproduce this with a newly
installed (from initdb) database? If you can shrink down a test case to
something others can look at then we'd have a chance to try fixing it.
Otherwise, you will just need to work around it.

fwiw the "several postings" don't ring a bell (but I'm not on the
General list if that's where they appeared).

                       - Tom