Thread: Cannot create a table
Hello, I'm brand new to pgAdminII. I've created a new database (that seemed straight-forward), but the option to create a table is grayed out. I've tried the "refreshing the information below" button, even exited the program and restarted it. Nothing. I did multiple searched in the mailing lists. So, how do I create tables? And have I missed the link to the manual? Thanks, Eric
> -----Original Message----- > From: Eric Chambers [mailto:echambers@centrivity.com] > Sent: 10 March 2003 23:46 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Cannot create a table > > > Hello, I'm brand new to pgAdminII. I've created a new > database (that seemed straight-forward), but the option to > create a table is grayed out. I've tried the "refreshing the > information below" button, even exited the program and > restarted it. Nothing. Hi Eric, You cannot create a table until you have browsed into a schema. Click down the levels in the treeview a bit and you should be OK. > I did multiple searched in the > mailing lists. So, how do I create tables? And have I missed > the link to the manual? It's on the Help menu, but docs aren't pgAdmin's strong point I'm afraid. Regards, Dave.
Attachment
Is it just me, or do all of you have trouble with groups? I tried to do some group-stuff, but pgAdmin yelled about some errors... What I did: - connect to the database (it has some old groups, maybe that's the trick, so I mention it ;->) - unfold the group-option - right-click on a group to ask for its properties I get the error: An error has occurred in pgAdminII:frmGroup.Initialize: Number: 35603 Description: Invalid Key My apologies for whining... Michiel "Dave Page" <dpage@vale-housing.co.uk> To: "Eric Chambers" <echambers@centrivity.com>, <pgadmin-support@postgresql.org> Sent by: cc: pgadmin-support-owner@post Fax to: gresql.org Subject: Re: [pgadmin-support] Cannot create a table 11-03-2003 01:04 > -----Original Message----- > From: Eric Chambers [mailto:echambers@centrivity.com] > Sent: 10 March 2003 23:46 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Cannot create a table > > > Hello, I'm brand new to pgAdminII. I've created a new > database (that seemed straight-forward), but the option to > create a table is grayed out. I've tried the "refreshing the > information below" button, even exited the program and > restarted it. Nothing. Hi Eric, You cannot create a table until you have browsed into a schema. Click down the levels in the treeview a bit and you should be OK. > I did multiple searched in the > mailing lists. So, how do I create tables? And have I missed > the link to the manual? It's on the Help menu, but docs aren't pgAdmin's strong point I'm afraid. Regards, Dave.
> -----Original Message----- > From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl] > Sent: 11 March 2003 08:26 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Cannot create a table > > > > Is it just me, or do all of you have trouble with groups? > I tried to do some group-stuff, but pgAdmin yelled about some > errors... What I did: > - connect to the database (it has some old groups, maybe > that's the trick, so I mention it ;->) > - unfold the group-option > - right-click on a group to ask for its properties > > I get the error: An error has occurred in > pgAdminII:frmGroup.Initialize: > Number: 35603 > Description: Invalid Key Do you have any odd group names? Can you supply a Full Debug log up to and including the error please (under Tools -> Options)? Regards, Dave.
Attachment
Hi Michiel, My guess is that you have some numeric-only usernames on your system - this caused exactly the same problem on my system when I was testing. I have fixed this now - can you please try the snapshot from the binaries folder at http://cvs.pgadmin.org/. Installation instructions are in the readme. Regards, Dave. > -----Original Message----- > From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl] > Sent: 11 March 2003 15:42 > To: Dave Page > Subject: Re: [pgadmin-support] Cannot create a table > > > > Argh... > > One should include the file when promising it! :) > > (See attached file: psqlodbc_1516.log)(See attached file: pgAdmin > II_1836.Log) > Michiel > > > > > > > "Dave Page" > > > <dpage@vale-housing.co.uk> To: > <Michiel_Lange@actuera.nl>, <pgadmin-support@postgresql.org> > > Sent by: cc: > > > pgadmin-support-owner@post Fax to: > > > gresql.org Subject: > Re: [pgadmin-support] Cannot create a table > > > > > > > > 11-03-2003 16:01 > > > > > > > > > > > > > > > > -----Original Message----- > > From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl] > > Sent: 11 March 2003 08:26 > > To: pgadmin-support@postgresql.org > > Subject: Re: [pgadmin-support] Cannot create a table > > > > > > > > Is it just me, or do all of you have trouble with groups? > > I tried to do some group-stuff, but pgAdmin yelled about some > > errors... What I did: > > - connect to the database (it has some old groups, maybe that's the > > trick, so I mention it ;->) > > - unfold the group-option > > - right-click on a group to ask for its properties > > > > I get the error: An error has occurred in > > pgAdminII:frmGroup.Initialize: > > Number: 35603 > > Description: Invalid Key > > Do you have any odd group names? Can you supply a Full Debug > log up to and including the error please (under Tools -> Options)? > > Regards, Dave. > > >