agora inbox for postgres@postgres.berkeley.edu  
help / color / mirror / Atom feed
From: Ray E. Flanery Jr <flanery@tram.epm.ornl.gov>
To: postgres@postgres.Berkeley.EDU
Subject: Strange things
Date: Thu, 12 Jan 95 09:48:22 -0500
Message-ID: <9501121448.AA00220@tram.epm.ornl.gov> (raw)


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/



reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: flanery@tram.epm.ornl.gov
  Subject: Re: Strange things
  In-Reply-To: <9501121448.AA00220@tram.epm.ornl.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox