pgAdmin data grid editing date or time values - Mailing list pgadmin-support

From Paul Hughes
Subject pgAdmin data grid editing date or time values
Date
Msg-id 000201caf643$67a0beb0$36e23c10$@com.au
Whole thread Raw
Responses Re: pgAdmin data grid editing date or time values  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
Hi,

I'm running pgAdmin1.12.0 beta (on XP Pro SP3) against PostgreSQL 9.0 beta 1
server (on Vista Business Server).

Pressing the Delete key in the edit grid with a date or time field value
selected always causes pgAdmin to crash.

To reproduce, run the following script:

DROP TABLE IF EXISTS test_me;
CREATE TABLE test_me
( jobid integer NOT NULL, jobdate date NOT NULL, starttime time without time zone NOT NULL, CONSTRAINT "ixjobid"
PRIMARYKEY (jobid)
 
);
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (1, '2010-05-01',
'08:30:00');
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (2, '2010-05-05',
'15:30:00');
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (3, '2010-05-10',
'15:00:00');
INSERT INTO test_me(jobid, jobdate, starttime) VALUES (4, '2010-05-30',
'10:00:00');


Highlight the table in pgAdmin and click the edit grid button.
In the edit gridr, click in one of the date or time cells to highlight the
cell.
Click again to put the highlighted cell into edit mode (so it shows the
current value as selected text).
Press delete (this causes the crash).

I have also encountered random crashes whilst editing date and or time
values without pressing delete but I've been unable to reproduce these
reliably.

Regards, Paul Hughes.




pgadmin-support by date:

Previous
From: Richard Broersma
Date:
Subject: Re: reporting feature request
Next
From: Guillaume Lelarge
Date:
Subject: Re: pgAdmin data grid editing date or time values