(...)
>>>>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,
(...)
> Hmm - can you post your full table definition please, including any
> foreign keys and referenced tables?
(...)
Well, after fiddeling with that for about 2 hours I'm positively
puzzled. It looks like a random memory corruption problem that is not
easily reproducible.
1. (V 1.2.2) The original problem also occurs on another computer when
accessing the original database. So it is not just my (client) computer
acting up.
2. (V1.4.0b3) I have created a test table with:
-- drop table t;
create table t(v varchar(64) primary key) without oids;
COMMENT ON TABLE t IS 'Betriebssystem-Namen für Auswahlliste';
On the first attempt, the edit grid refused to insert data and
complained about an syntax error at ')' at character 15.
I dropped and re-created the table and after that, the edit grid worked
and continued to work. I have not been able to reproduce this behaviour.
3. (V1.4.0b3) The problem goes away when I export the database and
recreate it (on the same server, but with a different name). The tables
in the original database still do not work.
4. (V1.4.0b3) If I cannot insert data, deleting from the edit grid also
crashes pgAdmin.
5. (V1.4.0b3) The original table definition, as shown by pgAdmin, is
CREATE TABLE osnames
( name varchar(64) NOT NULL, CONSTRAINT osnames_name_pkey PRIMARY KEY (name)
)
WITHOUT OIDS;
ALTER TABLE osnames OWNER TO ip;
COMMENT ON TABLE osnames IS 'Betriebssystem-Namen für Auswahlliste'
6. (unrelated, has been mentioned in another thread too) Backup does not
work with V1.4.0b3. It looks as if pgAdmin tries to spawn another
process to do the pg_dump, but the name of the command is missing from
the command line. pgAdmin crashes after the attempt. This suggests a
sprintf() pointer problem while assembling the command line.
I'm sorry, but I am unable to narrow the problem down any further.
Regards,
Harald Fricke