From: | "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: UpGrading to 7.1.2 |
Date: | 2001-08-09 23:11:50 |
Message-ID: | 5.0.2.1.0.20010809191032.00a36d50@pop.mindspring.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom,
Thank you This is what I was looking for. Unfortunately for me I took the
advice of the others who wrote and manually backed up each db
seperately. But from here on out I will know as well as everyone else on
the list.
Again Thank you Tom
At 03:43 PM 8/9/01 -0400, Tom Lane wrote:
>"Brian C. Doyle" <bcdoyle(at)mindspring(dot)com> writes:
> > Okay here is the problem this database no longer exist At some point the
> > dir path for it got removed and I do not know when or why I did that with
> > out dropdb. So postgres is still thinking it should be there.
>
> > How do I get postgres to stop thinking it is there
>
>DELETE FROM pg_database WHERE datname = 'foo';
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | Susan Lane | 2001-08-10 00:29:07 | Database handle error |
Previous Message | Lee Harr | 2001-08-09 22:54:15 | Re: ERROR: AlterTableAddConstraint: |