Обсуждение: pgadmin problem

Поиск
Список
Период
Сортировка

pgadmin problem

От
"David Chapman"
Дата:
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

Re: pgadmin problem

От
"Dave Page"
Дата:
 

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of David Chapman
Sent: 08 March 2005 12:26
To: pgadmin-support@postgresql.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.
 
Hi David,
 
It sounds like you are trying to type into the properties tabset which is indeed read-only. If you expand the node in the treeview on the right for your new database, you should see nodes for casts, schemas, languages etc. Open up the schemas node, and you should see a public schema. Open that and you'll see nodes for tables, views etc. You can right click nodes at every level in the hierarchy, and will see appropriate options on the popup menu - amongst those are options to create new objects of applicable types, each of which will open an object-specific dialog with which you can define what you want to create.
 
HTH,
 
Regards Dave.

Re: pgadmin problem

От
"James Prichard"
Дата:

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@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of David Chapman
Sent: 08 March 2005 12:26
To: pgadmin-support@postgresql.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

Re: pgadmin problem

От
"Dave Page"
Дата:
[Please keep replies on-list]

From: David Chapman [mailto:luckydavid@optusnet.com.au]
Sent: 09 March 2005 14:16
To: Dave Page
Subject: RE: [pgadmin-support] pgadmin problem

Thanks for replying Dave.

 

The instructions you have given exactly describe what I have been doing to display the  "Properties|Columns|Constraints|Privileges|SQL" page on which I should be able to create new objects. I can enter details into the properties page and so give my new table a name, but all other pages are read only – especially Columns. Without columns the table is not recorded.

 

To add a column you click the 'Add' button on the Columns tab...

 

Could it be that I am not able to see the bottom of this screen? There are no scroll bars – it appears to be interrupted by the program bar at the bottom of the screen.

 

I suspect an installation problem because pgAdmin’s  Elephant icon is suggesting that the application is in a read only mode. 

 

I'm not sure what you mean - the elephant icon is just an icon. It doesn't change to show the application status (and particularly not read-only mode, because there isn't one :-) ) 

 

Perhaps you could provide a screenshot of the problem?

 

Regards Dave.