The following bug has been logged online:
Bug reference: 1448
Logged by: Nikola Ivanov
Email address: nikola_ivanov@yahoo.com
PostgreSQL version: 8.0.0
Operating system: Windows XP Pro, Windows 2000 Pro
Description: pgAdmin III crashes on insert/update/delete
Details:
I am using pgAdmin III to do most of the daily table maintenance and data
manipulation, and it works well.
However, I face a problem when I edit the table definition and then try to
manipulate the data within that table.
More precisely, imagine I have a table called tab1. I create the tab1 with
several columns, col1, col2, and col3, and several constraints con1, con2. I
add the data to it by right clicking on the table and choosing View Data
option. Then I just manually enter the data into the row and hit enter and
it works.
Here is the weird part. Later on I decide I need to add another columnt,
col4, or remove a column col1, or change the type of a column col2, or add a
constraint con3, or all these things together. I am successful in doing so.
However, once I try to add the record by selecting View Data and typing it
in manually or update a record, whenever I hit enter pgAdmin III crashes
with this OS error:
"The instruction at '0x0041fa58' referenced memory at '0x050504f8'. The
memory could not be 'read'."
After I click OK, it terminates pgAdmin III. If I restart the pgAdmin III
and try again, I will get the same error (sometimes addresses are different,
but most of the time they are the same).
I tried stopping postgres service and restarting it, but that didn't help.
The user has all the necessary permissions to insert, update, delete, and
select from tab1.
Here is another tricky fact. If I try to insert a record to tab1 through
psql command line, it works. I can see it in pgAdmin later, but I still
cannot insert or update or delete without crashing it.
I tried installing pgAdmin on several different machines and the result is
same.