Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199501121448.GAA26348@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Thu, 12 Jan 95 09:48:22 -0500
From: flanery@tram.epm.ornl.gov (Ray E. Flanery Jr)
Message-Id: <9501121448.AA00220@tram.epm.ornl.gov>
To: postgres@postgres.Berkeley.EDU
Subject: Strange things
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 12 Jan 95 06:48:25 -0800
Resent-XMts: smtp


1) I am reinitializing the POSTGRES database, cleardbdir works fine. If I
   check ~postgres/data/* the only thing left there is the 'files' directory.
   When I run initdb, it appears to set everything up properly, except that
   when I go to add users, the ones who had access to the old database
   already exist?!? How can this be?

2) I have created a database and now attempt to DEFINE a type and a function.
   a) if I am doing this using the pqlib from code, it tells me they already
      exist, if I do it from the command line, everything is fine?!?

It almost seems as if re-initializing the db has kept around some copy
of the previous set-up.
---------------------------------------------------------------------------
                   Raymond E. Flanery Jr., Director
             Advanced Visualization Research Center, ORNL
 (615)574-0630                                     flanery@msr.epm.ornl.gov 
 (615)574-0680 fax                        http://www.epm.ornl.gov/~flanery/
----------------------------------------------------------------------------
                            Cleveland Browns
---------------------------------------------------------------------------
  "When the last individual of a race of living things breathes no more,
another heaven and another earth must pass before such a one can be again."
                           --- William Beebe
---------------------------------------------------------------------------
               "Loyalty above all else, except honor"  ---  


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/