#189: pgAdmin data grid editing date or time values
-------------------------+--------------------------------------------------
Reporter: Paul Hughes | Owner: gleu
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: editgrid | Platform: all
-------------------------+--------------------------------------------------
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" PRIMARY KEY (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.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/189>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III