Re: Problem with inserting data in table through pgAdmin

---

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] 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