Unix Technical Forum

Problem with inserting data in table through pgAdmin

This is a discussion on Problem with inserting data in table through pgAdmin within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> Hello, I have found something that looks like a bug. I checked the FAQ and the PG admin website ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:09 PM
RAAD Umar
 
Posts: n/a
Default 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 raa@dsr.ch

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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:03 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com