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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])