Thread: Error number 35603 Invalid key
I am new to pgAdminII and do not understand the following:
(Errors when trying to create tables)
Creating a database succeeds.
Then, when right-clicking it and selecting Create Object - Table
I get a dialog with error in frmTable.Initialise
Number 35603
Description: Invalid key
I press OK en get the Table form.
I can type a name but not an owner
I then add one or two columns
But when I press OK to create the table I get:
error frmTable.cmdOK_Click
Number: 91
Description: Object variable or With block variable not set
I can create the table using SQL but the Table form would be nice :-)
I am using Win2000Pro and have the following (no duplicates):
C:\WINNT\system32\COMDLG32.OCX (ver 6.0.84.18)
C:\WINNT\system32\COMCT332.OCX (ver 6.0.0.8450)
C:\WINNT\system32\COMCTL32.OCX (ver 6.0.81.5)
================
Mr. JP (Petri) Jooste
Skool vir Modelleringswetenskappe
School of Modelling Sciences
Vaal Triangle Campus
Potchefstroom University for Christian Higher Education
South Africa
*************************************************
Hierdie boodskap (en aanhangsels) is onderhewig aan beperkings en 'n vrywaringsklousule. Volledige besonderhede
beskikbaarby http://www.puk.ac.za/itb/e-pos/disclaimer.html , of by itbsekr@puknet.puk.ac.za
This message (and attachments) is subject to restrictions and a disclaimer. Please refer to
http://www.puk.ac.za/itb/e-pos/disclaimer.htmlfor full details, or at itbsekr@puknet.puk.ac.za
Hi, Can you recreate the error with logging switched to Full Debug (under Tools -> Options) and send the logfiles please? Regards, Dave. > -----Original Message----- > From: Petri Jooste [mailto:RKWJPJ@puknet.puk.ac.za] > Sent: 22 October 2002 10:48 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Error number 35603 Invalid key > > > I am new to pgAdminII and do not understand the following: > > (Errors when trying to create tables) > Creating a database succeeds. > Then, when right-clicking it and selecting Create Object - Table > I get a dialog with error in frmTable.Initialise > Number 35603 > Description: Invalid key > I press OK en get the Table form. > I can type a name but not an owner > I then add one or two columns > But when I press OK to create the table I get: > error frmTable.cmdOK_Click > Number: 91 > Description: Object variable or With block variable not set > > I can create the table using SQL but the Table form would be nice :-) > > > I am using Win2000Pro and have the following (no duplicates): > C:\WINNT\system32\COMDLG32.OCX (ver 6.0.84.18) > C:\WINNT\system32\COMCT332.OCX (ver 6.0.0.8450) > C:\WINNT\system32\COMCTL32.OCX (ver 6.0.81.5) > > > > > > > > ================ > Mr. JP (Petri) Jooste > Skool vir Modelleringswetenskappe > School of Modelling Sciences > Vaal Triangle Campus > Potchefstroom University for Christian Higher Education > South Africa > > ************************************************* > Hierdie boodskap (en aanhangsels) is onderhewig aan > beperkings en 'n vrywaringsklousule. Volledige besonderhede > beskikbaar by http://www.puk.ac.za/itb/e-pos/disclaimer.html > , of by itbsekr@puknet.puk.ac.za > > This message (and attachments) is subject to restrictions and > a disclaimer. Please refer to > http://www.puk.ac.za/itb/e-pos/disclaimer.html > for full > details, or at itbsekr@puknet.puk.ac.za > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) >
Thanks for the reply. I tried to recreate the error but cannot at the moment because the linux machine with the postgres server is not available. Then I tried to recreate the error using postgres on cygwin and now I do not get the error. My first guess is that it has something to do with permissions, because now (on cygwin) the Table form of pgAdmin get its "owner" field automatically filled with my username. The linux-based postgres has been set up to use md5 authentication. Could that be the problem ? ================ Mr. JP (Petri) Jooste Skool vir Modelleringswetenskappe School of Modelling Sciences Vaal Triangle Campus Potchefstroom University for Christian Higher Education South Africa ************************************************* Hierdie boodskap (en aanhangsels) is onderhewig aan beperkings en 'n vrywaringsklousule. Volledige besonderhede beskikbaarby http://www.puk.ac.za/itb/e-pos/disclaimer.html , of by itbsekr@puknet.puk.ac.za This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.puk.ac.za/itb/e-pos/disclaimer.htmlfor full details, or at itbsekr@puknet.puk.ac.za >>> "Dave Page" <dpage@vale-housing.co.uk> 10/22/02 11:59 >>> Hi, Can you recreate the error with logging switched to Full Debug (under Tools -> Options) and send the logfiles please? Regards, Dave. > -----Original Message----- > From: Petri Jooste [mailto:RKWJPJ@puknet.puk.ac.za] > Sent: 22 October 2002 10:48 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Error number 35603 Invalid key > > > I am new to pgAdminII and do not understand the following: > > (Errors when trying to create tables) > Creating a database succeeds. > Then, when right-clicking it and selecting Create Object - Table > I get a dialog with error in frmTable.Initialise > Number 35603 > Description: Invalid key > I press OK en get the Table form. > I can type a name but not an owner > I then add one or two columns > But when I press OK to create the table I get: > error frmTable.cmdOK_Click > Number: 91 > Description: Object variable or With block variable not set > > I can create the table using SQL but the Table form would be nice :-) > > > I am using Win2000Pro and have the following (no duplicates): > C:\WINNT\system32\COMDLG32.OCX (ver 6.0.84.18) > C:\WINNT\system32\COMCT332.OCX (ver 6.0.0.8450) > C:\WINNT\system32\COMCTL32.OCX (ver 6.0.81.5) > > > > > > > > ================ > Mr. JP (Petri) Jooste > Skool vir Modelleringswetenskappe > School of Modelling Sciences > Vaal Triangle Campus > Potchefstroom University for Christian Higher Education > South Africa > > ************************************************* > Hierdie boodskap (en aanhangsels) is onderhewig aan > beperkings en 'n vrywaringsklousule. Volledige besonderhede > beskikbaar by http://www.puk.ac.za/itb/e-pos/disclaimer.html > , of by itbsekr@puknet.puk.ac.za > > This message (and attachments) is subject to restrictions and > a disclaimer. Please refer to > http://www.puk.ac.za/itb/e-pos/disclaimer.html > for full > details, or at itbsekr@puknet.puk.ac.za > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) >
> -----Original Message----- > From: Petri Jooste [mailto:RKWJPJ@puknet.puk.ac.za] > Sent: 23 October 2002 08:05 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Error number 35603 Invalid key > > > Thanks for the reply. > I tried to recreate the error but cannot at the moment > because the linux machine with the postgres server is not > available. Then I tried to recreate the error using postgres > on cygwin and now I do not get the error. My first guess is > that it has something to do with permissions, because now (on > cygwin) the Table form of pgAdmin get its "owner" field > automatically filled with my username. > The linux-based postgres has been set up to use md5 > authentication. Could that be the problem ? Shouldn't be if you can login. On the Linux box, (when it's back up), will it let you execute the query: SELECT * FROM pg_user Thinking about it, if the create table dialogue doesn't list all the users on the system (because you can read them) then it might well have trouble. I would be surprised that you weren't getting an error earlier though. Anyway, hopefully the logs will tell when the Linux box is available again. Regards, Dave.