Обсуждение: 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.

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.

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.
>
>
>