Re: RE : RE : 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:dpage(at)vale-housing(dot)co(dot)uk]
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:raa(at)dsr(dot)ch]
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:dpage(at)vale-housing(dot)co(dot)uk]
Envoyé : vendredi, 23. septembre 2005 09:02
À : RAAD Umar; pgadmin-support(at)postgresql(dot)org
Objet : RE: [pgadmin-support] Problem with inserting data in table through pgAdmin

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of RAAD Umar
Sent: 21 September 2005 09:22
To: pgadmin-support(at)postgresql(dot)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/ <http://developer.pgadmin.org/> and let us know if you see the problem with that version as well please?

Regards, Dave