| From: | "P(dot) Dwayne Miller" <dmiller(at)espgroup(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: database does not exist in system catalog |
| Date: | 2001-08-06 21:36:39 |
| Message-ID: | 3B6F0DE7.D26E6FF1@espgroup.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
How did you create this database?
Kathi Arthur wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_00B0_01C11E7E.4FFBA910
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Please bear with me for a stupid new-user question. I've tried to solve my=
> problem by looking at the online documentation, FAQs and archived list ser=
> vs (all very helpful!). But after most of the night Friday and most of las=
> t night, I still don't get it...
>
> I have a database that is already created and sitting out there. I can't a=
> ccess it (Fatal 1: Database "my db" does not exist in the system catalog").
>
> I don't want to run CREATE DATABASE because the table schemas I want alread=
> y exist. I don't care about the data -- just the schemas and attributes.
>
> Can you help me figure out what steps I need to go through to add this db t=
> o the data dictionary (system catalog)? Right now, all I can access is tem=
> plate1.
>
> I'm running PostgreSQL 7.0.2 on an alpha running FreeBSD.
>
> Help! TIA.
>
> Kathi Arthur
> Colorado Mountain College
> karthur(at)coloradomtn(dot)edu
>
> ------=_NextPart_000_00B0_01C11E7E.4FFBA910
> Content-Type: text/html; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Please bear with me for a stupid new-user=
> =20
> question. I've tried to solve my problem by looking at the online=20
> documentation, FAQs and archived list servs (all very helpful!). But =
> after=20
> most of the night Friday and most of last night, I still don't get=20
> it...</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>I have a database that is already created =
> and=20
> sitting out there. I can't access it (Fatal 1: Database "my db"=
> does=20
> not exist in the system catalog").</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>I don't want to run CREATE DATABASE becaus=
> e the=20
> table schemas I want already exist. I don't care about the data -- ju=
> st=20
> the schemas and attributes.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Can you help me figure out what steps I ne=
> ed to go=20
> through to add this db to the data dictionary (system catalog)? Right=
> now,=20
> all I can access is template1.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>I'm running PostgreSQL 7.0.2 on an alpha r=
> unning=20
> FreeBSD.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Help! TIA.</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Kathi Arthur</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>Colorado Mountain College</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2><A=20
> href=3D"mailto:karthur(at)coloradomtn(dot)edu">karthur(at)coloradomtn(dot)edu</A></FONT><=
> /DIV></BODY></HTML>
>
> ------=_NextPart_000_00B0_01C11E7E.4FFBA910--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-08-06 21:44:38 | Re: database does not exist in system catalog |
| Previous Message | Tom Lane | 2001-08-06 21:27:02 | Use int8 for int4/int2 aggregate accumulators? |