Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support

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


Attachment: pgadmin_excerpt.log
Description: text/plain (4.2 KB)


pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group