strange (win32 only?) row deletion bug report

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: strange (win32 only?) row deletion bug report
Date: 2004-09-08 11:27:10
Message-ID: 413EEC8E.9070701@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

hi!

i've come across a strange bug. i have a table, some rows inserted and
i'm viewing the data inside. in the table i can edit data, i have some
unique constraints and a pk set.
column user_id (primary key) has rows with values from 59 to 69. if i
select the rows by clicking on the row number fields on the left-hand
side of the table, specifically in this case i click on no. 3 and drag
down to select all to row 13. i then click on the delete selected rows
icon. so far, all's ok.
i reinserted the data, user_id values range from 70 to 80. again i wish
to delete the rows, but i select row 13 first and drag the mouse _up_ to
no. 3. rows are all selected and i click delete rows again. in this
case, pgadmin3 crashes. however, it does delete every second row of
data, in my table, i still have records with user_id's 71, 73, 75, 77
and 79. the rest got deleted.

the error is not very specific, the standard windows "pgadmin3.exe has
generated errors and will be closed by windows. you will need to restart
the program. an error log is being created."

attached i also send the relevant lines from pgadmin.log. i also changed
the log level to debug and tried deleting the remaining lines. this is
all that was in the log file that had anything to do with it:

2004-09-08 13:04:46 INFO : Destroying an options dialogue
2004-09-08 13:04:57 QUERY : Void query (localhost:5432): DELETE FROM
users WHERE user_id = '71'::int4
2004-09-08 13:04:57 QUERY : Void query (localhost:5432): DELETE FROM
users WHERE user_id = '75'::int4
2004-09-08 13:04:57 QUERY : Void query (localhost:5432): DELETE FROM
users WHERE user_id = '79'::int4
next entry is about starting up the application...

only the queries, nothing else. the same happened on another snapshot i
had lying around and gave it a try, haven't tested with other versions.
i only have win2k so i cannot say this also happens on other platforms.
there is nothing in the event log.

info: pgadmin3 snapshot, 1.1.0 devel, 20040907 (and also 20040829)
server: pgsql-8.0-beta1 on windows 2000, sp4

--
lp,
M

Attachment Content-Type Size
pgadmin_excerpt.log text/plain 4.2 KB

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-09-08 12:32:19 Re: strange (win32 only?) row deletion bug report
Previous Message Priowirjanto 2004-09-08 07:47:09 Error Message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.