Hello all,
I have got a strange problem with pgAdmin III 1.2.2 on Windows XP SP2.
I've got a table with only one column (also primary key) of type
varchar. pgAdmin crashes every time I insert a new row in the edit grid,
either when hitting enter or pressing the store button. The crash
actually happens after committing the change. The new data is there when
I restart pgAdmin.
Can anybody reproduce this?
Regards,
Harald Fricke
Last entries from pgadmin.log:
2005-10-21 15:37:24 INFO : Creating EditGrid
2005-10-21 15:37:24 INFO : Running query SELECT * FROM osnames ORDER
BY name ASC
2005-10-21 15:37:24 QUERY : Thread Query SELECT * FROM osnames ORDER BY
name ASC
2005-10-21 15:37:24 INFO : Creating pgSet object
2005-10-21 15:37:24 QUERY : Set query (192.168.10.147:5432): SELECT
n.nspname AS nspname, relname, t.typname, nt.nspname AS typnspname,
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_namespace nt ON nt.oid=t.typnamespace
JOINpg_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
attisdroppedAND attrelid=45897::oid ORDER BY attnum
2005-10-21 15:37:24 INFO : Creating pgSet object
2005-10-21 15:37:24 INFO : Destroying pgSet object
2005-10-21 15:37:27 INFO : Destroying pgSet object
2005-10-21 15:37:32 QUERY : Set query (192.168.10.147:5432): INSERT
INTO osnames(name) VALUES ('gaga'::pg_catalog."varchar")
2005-10-21 15:37:32 INFO : Creating pgSet object
2005-10-21 15:37:32 INFO : Destroying pgSet object
~
