[pgadmin-support] Problem with inserting data in table through pgAdmin
Hello, I have found something that looks like a bug. I checked the FAQ and the PG admin website but didn’t find any information about it. I also installed the last available version (1.2.2) My system: - Win 2000 SP4 in French + Service rollout - All patches - Postgres 8.0.3 - PGAdmin 1.2.2 My problem: I can’t add data in a table of a test database I created through the PGAdmin interface. If I do that I receive a Windows message that tells me: « pgAdmin3.exe a généré des erreurs et sera fermé par Windows. » That means in English : “pgAdmin3.exe has caused an error and will be closed by Windows.” The exact description on how I caused the error. - Standard download and install of the last version of PG 8.0.3 and pgAdmin 1.2.2 - Opening pgAdmin and using it for: o Creation of the database “TEST” o Creation of the table “BOOKS” o Creation of the column “BOOK_ID” (int8) o Creation of the column “BOOK_TITLE” (text) o Configuration of the column “BOOK_ID” as primary key o Going to “Servers” --> “PostgreSQL Database Server 8.0” --> “Databases” --> “test” --> “Schemas” --> “Public” --> “Tables” --> “BOOKS” o Right-clicking on “BOOKS” and selecting “view data” o Typing a title in “BOOK_TITLE” and a unique number in “BOOK_ID” o Pressing enter o CRASH This error is systematic and happens each time I try to add data this way. Thank you for your help and best regards, Umar RAAD Ingénieur système MCSE Informatique DSR 14, av. Riond-Bosson Case postale 2203 CH – 1110 Morges 2 Tél. direct +41 (0)21 804 55 03 Tél. central (0)21 804 55 55 Fax +41 (0)21 804 55 00 E-mail [EMAIL PROTECTED] Internet www.dsr.ch --- Le contenu de ce message et ses éventuelles annexes sont de nature confidentielle. Si vous avez reçu ce message et ses éventuelles annexes par erreur, nous vous saurions gré de bien vouloir les détruire et d'en informer l'expéditeur. Toute publication, utilisation, copie ou distribution tant partielle que totale est strictement interdite et passible de poursuites judiciaires. Der Inhalt dieser Mitteilung und ihrer möglichen Anhänge sind von vertraulicher Natur. Wenn Sie diese Mitteilung und ihre möglichen Anhänge aus Versehen erhalten haben, wären wir Ihnen dankbar, sie zu zerstören, und darüber den Absender zu informieren. Jede Veröffentlichung, Benutzung, Kopie oder Verteilung sowohl partiell als auch voll ist und verantwortlich von gerichtlichen Verfolgungen strikt verboten. The contents of this message and its possible annex are of confidential nature. If you received this message and its possible annex by error, we would be grateful to you for agreeing to destroy them and for informing the shipper of it. Any publication, use, copy or distribution as well partial as total is strictly prohibited and liable to legal proceedings.
RE : RE : [pgadmin-support] Problem with inserting data in table through pgAdmin
Hello, Sorry for the late answer… I was away a few days and saw your post only now. Sorry no… It doesn’t work. I downloaded and installed the last available snapshot. Actually my pgadmin identifies itself as Version 1.3.0 (19 sept 2005) but I still have the same bug. Anyway… Thanks for your help Umar Hello, I have found something that looks like a bug. I checked the FAQ and the PG admin website but didn’t find any information about it. I also installed the last available version (1.2.2) My system: - Win 2000 SP4 in French + Service rollout - All patches - Postgres 8.0.3 - PGAdmin 1.2.2 My problem: I can’t add data in a table of a test database I created through the PGAdmin interface. If I do that I receive a Windows message that tells me: « pgAdmin3.exe a généré des erreurs et sera fermé par Windows. » That means in English : “pgAdmin3.exe has caused an error and will be closed by Windows.” The exact description on how I caused the error. - Standard download and install of the last version of PG 8.0.3 and pgAdmin 1.2.2 - Opening pgAdmin and using it for: o Creation of the database “TEST” o Creation of the table “BOOKS” o Creation of the column “BOOK_ID” (int8) o Creation of the column “BOOK_TITLE” (text) o Configuration of the column “BOOK_ID” as primary key o Going to “Servers” --> “PostgreSQL Database Server 8.0” --> “Databases” --> “test” --> “Schemas” --> “Public” --> “Tables” --> “BOOKS” o Right-clicking on “BOOKS” and selecting “view data” o Typing a title in “BOOK_TITLE” and a unique number in “BOOK_ID” o Pressing enter o CRASH This error is systematic and happens each time I try to add data this way. Hello, Can you test the latest snapshot from http://developer.pgadmin.org/ and let us know if you see the problem with that version as well please? Regards, Dave
Re: RE : RE : [pgadmin-support] Problem with inserting data in table through pgAdmin
Hello, I just tried a full reinstall on a clean procedure with a little variation of the standard installation an dit worked. What I did: - Download and install W32 package of Postgres 8.0.3 on a win2000 Fr Full patched. - In the installation options I Deselected PGAdminIII - I installed separately the latest snapshot from http:// developer.pgadmin.org Now everything’s OK. Thank you for your help and good continuation. Regards, Umar -Message d'origine- De : Dave Page [mailto:[EMAIL PROTECTED] Envoyé : vendredi, 30. septembre 2005 11:07 À : RAAD Umar Objet : RE: RE : [pgadmin-support] Problem with inserting data in table through pgAdmin HI, I've just followed your steps below and just can't repeat the problem I'm afraid. Can you try switching the logging to debug level (under File -> Options), repeating the problem and sending the log? I'm not sure how much it will show us in this case, but it's worth a try. Is anyone else on the list able to repeat this problem? Regards, Dave From: RAAD Umar [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 14:34 To: Dave Page Subject: RE : [pgadmin-support] Problem with inserting data in table through pgAdmin Hello, Sorry for the late answer… I was away a few days and saw your post only now. Sorry no… It doesn’t work. I downloaded and installed the last available snapshot. Actually my pgadmin identifies itself as Version 1.3.0 (19 sept 2005) but I still have the same bug. Anyway… Thanks for your help Umar -Message d'origine- De : Dave Page [mailto:[EMAIL PROTECTED] Envoyé : vendredi, 23. septembre 2005 09:02 À : RAAD Umar; pgadmin-support@postgresql.org Objet : RE: [pgadmin-support] Problem with inserting data in table through pgAdmin From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of RAAD Umar Sent: 21 September 2005 09:22 To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Problem with inserting data in table through pgAdmin Hello, I have found something that looks like a bug. I checked the FAQ and the PG admin website but didn’t find any information about it. I also installed the last available version (1.2.2) My system: - Win 2000 SP4 in French + Service rollout - All patches - Postgres 8.0.3 - PGAdmin 1.2.2 My problem: I can’t add data in a table of a test database I created through the PGAdmin interface. If I do that I receive a Windows message that tells me: « pgAdmin3.exe a généré des erreurs et sera fermé par Windows. » That means in English : “pgAdmin3.exe has caused an error and will be closed by Windows.” The exact description on how I caused the error. - Standard download and install of the last version of PG 8.0.3 and pgAdmin 1.2.2 - Opening pgAdmin and using it for: o Creation of the database “TEST” o Creation of the table “BOOKS” o Creation of the column “BOOK_ID” (int8) o Creation of the column “BOOK_TITLE” (text) o Configuration of the column “BOOK_ID” as primary key o Going to “Servers” --> “PostgreSQL Database Server 8.0” --> “Databases” --> “test” --> “Schemas” --> “Public” --> “Tables” --> “BOOKS” o Right-clicking on “BOOKS” and selecting “view data” o Typing a title in “BOOK_TITLE” and a unique number in “BOOK_ID” o Pressing enter o CRASH This error is systematic and happens each time I try to add data this way. Hello, Can you test the latest snapshot from http://developer.pgadmin.org/ and let us know if you see the problem with that version as well please? Regards, Dave
