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
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=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
~
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
