pgAdmin III 1.2.2 edit grid crashes with single-column tables

From: "Dr(dot) Harald Fricke" <hfricke(at)hdz-nrw(dot)de>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin III 1.2.2 edit grid crashes with single-column tables
Date: 2005-10-21 13:44:10
Message-ID: 4358F0AA.9020205@hdz-nrw.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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
~

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-10-21 13:55:36 Re: pgAdmin III 1.2.2 edit grid crashes with single-column tables
Previous Message Dominik Blystak 2005-10-21 10:17:31 unsuscribe