From: | "Tamir Halperin" <tamir(at)brobus(dot)net> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | pgAdmin II questions |
Date: | 2003-03-30 18:33:13 |
Message-ID: | 985DF46E87E0C047A3670048DBCAD0556BFC@andrew.brobus.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I just finished upgrading from FreeBSD 4.6 to 4.8RC and I'm trying to do some things with pgAdmin II which are giving me problems.
I remember creating a db called taxcal and it's listed there. However, I don't remember creating a db called pgsql.
Is this a db that the postgresql needs or was it created by mistake, maybe as a result of an erroneous create command?
Also, I can't drop it (by right clicking on it and selecting drop object from the shortcut menu. After being warned that the action cannot be undone I agree and an error comes up:
"An error as occured in pgAdmin II:basActions.drop:
Number: -2147467259
Description: ERROR: DROP DATABASE: database "pgsql" is being accessed by other users
Another thing I need help with is the appearance of both "template0" as well as "template1". I can't seem to delete template0 because the error from the drop action informs me that it is marked as a template.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-03-30 20:21:43 | Re: pgAdmin II questions |
Previous Message | Peter Eisentraut | 2003-03-30 13:45:42 | Re: pg_dump restore problem |