Thread: Cannot run destroydb: ERROR: typeidTypeRelid: Invalid type - oid = 0

Hi again,

After failing to compile PostgreSQL on our Alpha workstations with egcs,
I now switched to the "native" compiler and got a somewhat running system.
I can create a database and put something in it (just tried a few numbers),
but I cannot destroy it. I get this error message:

    ERROR:  typeidTypeRelid: Invalid type - oid = 0

More precisely, the command

    psql -tq -p 4711 -c "drop database postgres" template1

produces the error message mentioned above, and a nonzero exit status.
I tried adding a semicolon to the SQL statement, and I also tried running
it interactively, but I got the error in all cases.

Can you help me solve this problem?

Greetinx & thanx in advanve, Jan
--
 +- Jan T. Kim -------------------------------------------------------+
 |             email: kim@mpiz-koeln.mpg.de                           |
 |             WWW:   http://www.mpiz-koeln.mpg.de/~kim/              |
 *-----=<  hierarchical systems are for files, not for humans  >=-----*

Hello,

I'm struggling with the methods of user authentication that Postgre uses.
I would like to be able to use the /etc/passwd or /etc/shadow file to
authenticate users.  That way users could easily control their own
passwords by telnet-ing in to the machine.

I've tried the following line in my pg_hba.conf file:

   "local        all                           password /etc/passwd"

But to no good return.  I think that my system (Linux 2.0.34) is using a
different encryption algorithm that Postgre.

For the password "temptemp", my system produces the following:

     "3aBwsRu.LzR4k"

While Postgre's pg_passwd yields:

     "VsHWG150vpTic"


Any insight into this matter would be greatly appreciated.

thanks much,
  Adam



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 Adam Maddock                                 http://Adam.Maddock.com
 Detroit, MI                                         adam@maddock.com
    "BE IMITATORS of God, therefore, as dearly loved children..."
                                                  (Ephesians 5:1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~