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