Thread: Can only create a database ?

Can only create a database ?

From
"Peter Depuydt"
Date:
Hi,

I can only create a database, no tables nor anything else.
I connect as a superuser.

Some versions :

postgresql : 7.2.2 on Redhat 8.0
psqlODBC : 7.2.5 on Windows 2000 Pro
pgAdmin II : 1.4.12 on Windows 2000 Pro

Has anyone got a clue ?

Kind regards

Peter Depuydt

Re: Can only create a database ?

From
"Dave Page"
Date:

> -----Original Message-----
> From: Peter Depuydt [mailto:peter@dynetix.be]
> Sent: 29 December 2002 13:38
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Can only create a database ?
>
>
> Hi,
>
> I can only create a database, no tables nor anything else.
> I connect as a superuser.
>
> Some versions :
>
> postgresql : 7.2.2 on Redhat 8.0
> psqlODBC : 7.2.5 on Windows 2000 Pro
> pgAdmin II : 1.4.12 on Windows 2000 Pro
>
> Has anyone got a clue ?

It was once rumoured :-)

When you have created a database, open it in the treeview, then open
Schemas/public. You can only create objects when you are under a
suitable container object. The current containers are displayed in the
status bar at the bottom.

Regards, Dave.