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