Skip site navigation (1) Skip section navigation (2)

Re: pgadmin problem

From: "James Prichard" <james(dot)prichard(at)markit(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Cc: "David Chapman" <luckydavid(at)optusnet(dot)com(dot)au>
Subject: Re: pgadmin problem
Date: 2005-03-08 10:05:58
Message-ID: A8D8891C40113445A567195896DC83AE8DFDFE@exch_svr.Dadd.local (view raw or flat)
Thread:
Lists: pgadmin-support
A postgresql server may contain multiple databases and each of these can
have its own set of user permissions.  Just opening pgadminIII doesn't
authorize you to do anything - or even to see much!

 

The pgadminIII application must first connect to a database as a
particular user.  E.g. the default database has a user called "postgres"
with a password which was set up at installation.

 

Connecting will allow you to expand the node and change properties
according to the users rights.

Under the hood pgadminIII is sending SQL statements to achieve the
changes even though the user sees a nice graphical UI.

 

See the "reverse engineered SQL" tab for the kind of syntax required.

 

In windows a right-click on a node brings up the relevant context-menu
while a left-click simply expands, contracts and selects nodes.  I
assume there is an equivalent mouse operation on your system.

 

-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of David Chapman
Sent: 08 March 2005 12:26
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] pgadmin problem

 

Good People,

 

I am slowly learning Postgresql, but are not having much luck with
pgadmin.

 

I can create a database, but are not able to add tables to the new
database. The overlaid page headed
"Properties|Columns|Constraints|Privileges|SQL" will not accept
characters from the keyboard. It appears to be in a read only mode -
which may be what the red circle with crossed through pencil indicates
on the elephant icon. I would not question it if I were not able to
create databases. The point is I don't know if I am on the right track,
and I don't know what to do about it.

 

The instance of postgresql is on my stand alone PC running Fedora C3. I
do not have any problems using psql in the tutorials in the PostgreSQL
documentation.

 

I will appreciate advice,

 

David

pgadmin-support by date

Next:From: David ChapmanDate: 2005-03-08 12:26:24
Subject: pgadmin problem
Previous:From: Dave PageDate: 2005-03-07 22:09:08
Subject: Re: pgadmin problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group