strange (win32 only?) row deletion bug report - Mailing list pgadmin-support
From | Miha Radej |
---|---|
Subject | strange (win32 only?) row deletion bug report |
Date | |
Msg-id | 413EEC8E.9070701@siix.com Whole thread Raw |
Responses |
Re: strange (win32 only?) row deletion bug report
|
List | 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 2004-09-08 12:51:41 QUERY : Thread Query SELECT * FROM users ORDER BY user_id ASC 2004-09-08 12:51:41 QUERY : Set query (localhost:5432): SELECT nspname, relname, t.typname, attname, COALESCE(b.oid, t.oid)AS basetype, atthasdef, adsrc, CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else t.typtypmod END AS typmod, CASE WHEN t.typbasetype::oid=0 THEN att.attlen else t.typlen END AS typlen FROM pg_attribute att JOIN pg_type t ON t.oid=att.atttypid JOIN pg_class c ON c.oid=attrelid JOIN pg_namespace n ON n.oid=relnamespace LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum WHERE attnum > 0 AND NOT attisdropped AND attrelid=17276::oid ORDER BY attnum 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '69'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '68'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '67'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '66'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '65'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '64'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '63'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '62'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '61'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '60'::int4 2004-09-08 12:55:31 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '59'::int4 2004-09-08 12:55:35 QUERY : Thread Query INSERT INTO users ( first_name ,second_name ,third_name ,username ,password ,email_address,street ,house_no ,zip_code ,city ,province ,state ,temp_street ,temp_house_no ,temp_zip_code ,temp_city ,temp_province,day_of_birth ,city_of_birth ,mobile ,phone ,fax ,id_document ,id_document_no ,bank ,bank_account_no ,swift_code,job ,title ,preferred_template ,session_activation ) VALUES ( NULLIF ('e', '') ,NULLIF ('fg', '') ,NULLIF ('puko','') ,'lkkujpog' ,'0cc175b9c0f1b6a831c399e269772661' ,NULLIF ('fjfdos@sfde.sk', '') ,NULLIF ('ertrt', '') ,NULLIF('56', '') ,NULLIF ('45345', '') ,NULLIF ('trzrzrtzt', '') ,NULLIF ('ufjdjghj', '') ,NULLIF (2, 0) ,NULLIF ('', ''),NULLIF ('', '') ,NULLIF ('', '') ,NULLIF ('', '') ,NULLIF ('', '') ,NULLIF ('1789-02-01', '')::date ,NULLIF ('', ''),NULLIF ('5465467365', '') ,NULLIF ('', '') ,NULLIF ('', '') ,NULLIF ('62456trhghjgj', '') ,NULLIF ('jtjtzu46784576373','') ,NULLIF ('35673567tzhthjtzjfgz', '') ,NULLIF ('7567567367', '') ,NULLIF ('567567', '') ,NULLIF ('rt 2004-09-08 12:55:37 QUERY : Thread Query SELECT * FROM users ORDER BY user_id ASC 2004-09-08 12:55:37 QUERY : Set query (localhost:5432): SELECT nspname, relname, t.typname, attname, COALESCE(b.oid, t.oid)AS basetype, atthasdef, adsrc, CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else t.typtypmod END AS typmod, CASE WHEN t.typbasetype::oid=0 THEN att.attlen else t.typlen END AS typlen FROM pg_attribute att JOIN pg_type t ON t.oid=att.atttypid JOIN pg_class c ON c.oid=attrelid JOIN pg_namespace n ON n.oid=relnamespace LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum WHERE attnum > 0 AND NOT attisdropped AND attrelid=17276::oid ORDER BY attnum 2004-09-08 12:59:17 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '70'::int4 2004-09-08 12:59:17 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '72'::int4 2004-09-08 12:59:17 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '74'::int4 2004-09-08 12:59:17 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '76'::int4 2004-09-08 12:59:17 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '78'::int4 2004-09-08 12:59:17 QUERY : Void query (localhost:5432): DELETE FROM users WHERE user_id = '80'::int4
pgadmin-support by date: